Join two dimension based on custom field User Picker and Assignee field

Questions & Answers
1

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])
)
)

2

Hi @seif

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:

(
  [Measures].[Issues created],
  [Delegates].[Delegates].GetMemberByKey(
    [Assignee].CurrentHierarchyMember.Name
  ),
  [Assignee].CurrentHierarchy.DefaultMember
)

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris