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.
image
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:

Nonemptystring(
Generate(
Filter(
Descendants([Assignee].CurrentMember, [Assignee].[User]),
(
[Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember
)> 0 
AND
[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

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