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

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 →
not IsEmpty([Measures].[Issues created])

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

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