Hi,
I would like to join two dimensions [assignee] and [ delegates] to get the total assignee + delegates
of the same user field is multi select userpicker ( dimension ) and jira default assignee.
The desire result: user x assigned to task = 1
user x delegate to task = 1
user x total tasks is = 2
It tried, row = delegates and with calculated measure →
Count(
Filter(
[Assignee].[User].Members,
not IsEmpty([Measures].[Issues created])
)
)
You can use the Assignee dimension in Rows and define a new calculated measure with the following formula to see how many tasks are delegated to each of the user in Rows: