How to get all the assignee of issues under a Epic

Need to build a calculated member that will hold the values of all the assignee of issues tagged under a Epic. I know we can build this to show a table of epics and when you expand it, it will show the subsequent parent and subtasks with the assignee. But we need something very simple as shown below.
Epics Assignees/collaboraters
Epic 1 Assignee 1, Assignee 2
Epic 2 Assignee 2, Assignee 3, Assignee 1
Epic 3 Assignee 4, Assignee 1

The assignee displayed across each Epic will be the assignee of the epic + assignee of subsequent parent and sub task issues. Is this possible? If yes, how can we achieve this?

Hi @Vinu

In this case, you could create a new calculated measure (with integer format) in “Measures” dimension that would generate all assignees of issues that belog to epic.
Try this code:

Descendants([Assignee].CurrentMember, [Assignee].[User]),
[Measures].[Issues created],
)> 0 
[Assignee].CurrentMember.Name <> "(unassigned)"), 
[Assignee].CurrentMember.Name, ', '

That would generate a string from unique assignees.
It may mislead you when you use it with “Time” dimension as it would generate assign

Martins / eazyBI

1 Like

Thats really cool @martins.vanags. This is exactly what I wanted. Thanks for your help.