# How to get all the assignee of issues under a Epic **URL:** \ **Category:** Questions & Answers\ **Tags:** jira-reports, hierarchy, calculatedmembers\ **Created:** [January 6, 2020, 10:26am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425 "2020-01-06T10:26:39Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Vinu](https://community.eazybi.com/letter_avatar_proxy/v4/letter/v/3be4f8/32.png) [@Vinu](https://community.eazybi.com/u/Vinu)\ **Post date:** [January 6, 2020, 10:26am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/1 "2020-01-06T10:26:39Z")
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](https://community.eazybi.com/uploads/default/original/2X/2/25e3f976d447ef15353bb05d20727547dcb81d83.png) 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? ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [January 6, 2020, 4:25pm UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/2 "2020-01-06T16:25:33Z")
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 ![assignees as calculated measure](https://community.eazybi.com/uploads/default/original/2X/0/0f1efa12fd744ca599d2656f4c6e29e3bbc97641.png) ---
**Author:** ![Vinu](https://community.eazybi.com/letter_avatar_proxy/v4/letter/v/3be4f8/32.png) [@Vinu](https://community.eazybi.com/u/Vinu)\ **Post date:** [January 7, 2020, 3:13pm UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/3 "2020-01-07T15:13:58Z")
Thats really cool @martins.vanags. This is exactly what I wanted. Thanks for your help. ---
**Author:** ![Taylor\_Quinn](https://community.eazybi.com/user_avatar/community.eazybi.com/taylor_quinn/32/9415_2.png) [@Taylor\_Quinn](https://community.eazybi.com/u/Taylor_Quinn)\ **Post date:** [April 25, 2023, 6:29pm UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/4 "2023-04-25T18:29:25Z")
@martins.vanags - is there a modification that can be made to allow for the Time dimension to be used with this code. As an example, I am trying to show what vehicles are assigned to all of the child issues for each epic. Ideally it would list the epic and then the vehicles for the children issues in one cell. I want to split it up per week though based on the creation date of the child issues. ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [April 26, 2023, 7:05am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/5 "2023-04-26T07:05:26Z")
@Taylor_Quinn How exactly do you assign the vehicle to a child of an epic (what field do you use in Jira to assign vehicle) and what issue types do you use in jira for epic children? Martins / eazyBI ---
**Author:** ![Taylor\_Quinn](https://community.eazybi.com/user_avatar/community.eazybi.com/taylor_quinn/32/9415_2.png) [@Taylor\_Quinn](https://community.eazybi.com/u/Taylor_Quinn)\ **Post date:** [April 26, 2023, 1:40pm UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/6 "2023-04-26T13:40:56Z")
@martins.vanags thank you for the quick response! All of the epic children are tasks. The vehicle is an asset stored in Insight and it links through a field called Vehicle. This is the current code that I am using: Nonemptystring( Generate( Filter( Descendants([Vehicle].CurrentMember, [Vehicle].[Vehicle]), ( [Measures].[Issues created], [Time].CurrentHierarchy.DefaultMember )\> 0 AND [Vehicle].CurrentMember.Name \<\> “(none)”), [Vehicle].CurrentMember.Name, ', ’ )) ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [April 26, 2023, 2:11pm UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/7 "2023-04-26T14:11:48Z")
@Taylor_Quinn What is the layout of the report (columns, rows, page filters) and what does your current formula calculate? Martins / eazyBI ---
**Author:** ![Taylor\_Quinn](https://community.eazybi.com/user_avatar/community.eazybi.com/taylor_quinn/32/9415_2.png) [@Taylor\_Quinn](https://community.eazybi.com/u/Taylor_Quinn)\ **Post date:** [April 26, 2023, 2:24pm UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/8 "2023-04-26T14:24:23Z")
I am currently calculating all of the vehicles listed in the children issues of the epic. My calculate field is “All Vehicles”. I am wanting to add the Time Dimension as a measure so I can break up which vehicles were used based on the week of the creation dates of the child issues (tasks). ![image](https://community.eazybi.com/uploads/default/original/2X/2/21da6db47e9ce0fb9fa95a256e9e876783f7a840.jpeg) ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [April 27, 2023, 12:01pm UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/9 "2023-04-27T12:01:43Z")
@Taylor_Quinn Try this formula: ```auto Nonemptystring( Generate( Filter( Descendants([Vehicle].CurrentMember, [Vehicle].[Vehicle]), ( [Measures].[Issues created] )> 0 AND [Vehicle].CurrentMember.Name <> “(none)”), [Vehicle].CurrentMember.Name, ', ’ )) ``` Then split the report by “Time” dimension at week level. It should generate vehicles created by weeks. Martins / eazyBI ---
**Author:** ![Taylor\_Quinn](https://community.eazybi.com/user_avatar/community.eazybi.com/taylor_quinn/32/9415_2.png) [@Taylor\_Quinn](https://community.eazybi.com/u/Taylor_Quinn)\ **Post date:** [April 27, 2023, 2:01pm UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/10 "2023-04-27T14:01:04Z")
that worked, thank you so much! ---
**Author:** ![ririsbars](https://community.eazybi.com/user_avatar/community.eazybi.com/ririsbars/32/14742_2.png) [@ririsbars](https://community.eazybi.com/u/ririsbars)\ **Post date:** [November 7, 2025, 7:37am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/11 "2025-11-07T07:37:23Z")
Hi Martins, Kindly need your advice, I want to create a report based on subtask assignees that shows where each person is involved, according to the subtasks assigned to them within a story. I’ve already tried using the formula below, but it only displays the story assignee. NonZero(Count( Filter( – Iterate over all Parent level issues that have children [Issue.Sub-task].[Parent].Members, ```auto -- Check if any sub-issue exists for the current Assignee context in the rows ([Measures].[Issues created], [Assignee].CurrentMember, [Issue.Sub-task].CurrentHierarchyMember) > 0 ``` ) )) result: ![image](https://community.eazybi.com/uploads/default/original/2X/d/dec34b0f9df319098ee9a0082ba31187065eceeb.png) ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [November 11, 2025, 11:48am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/12 "2025-11-11T11:48:03Z")
Hi @ririsbars Try this code for your calcualted measure. ```auto NonZero( sum( --filter parent level tickets from issue.subtask hierarchy Filter( DescendantsSet( [Issue.Sub-task].CurrentMember, [Issue.Sub-task].[Parent] ), --check if parents belong to page filters [Measures].[Issues created]>0 ), --return the sum of parent's children regardless of page filters Sum( Childrenset([Issue.Sub-task].CurrentMember), -- Check if any sub-issue exists for the current Assignee context in the rows DefaultContext(( [Measures].[Issues created], [Assignee].CurrentHierarchyMember, [Issue.Sub-task].CurrentMember )) ) ) ) ``` And please manually select “integer” output format for the measure. Martins / eazyBI ---
**Author:** ![ririsbars](https://community.eazybi.com/user_avatar/community.eazybi.com/ririsbars/32/14742_2.png) [@ririsbars](https://community.eazybi.com/u/ririsbars)\ **Post date:** [November 12, 2025, 3:18am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/13 "2025-11-12T03:18:40Z")
Hello Martins, thanks a lot for yout prompt response. But it seems I explained it incorrectly — what I actually meant was for the following condition: **Story A (unassign)** - Subtask a – assignee: Riris - Subtask b – assignee: Anna - Subtask c – assignee: Riris **Story B (unassign)** - Subtask d – assignee: Riris **Story C (unassign)** - Subtask e – assignee: Nanda And the report I want to display is: | Name | Number of Stories | | --- | --- | | Riris | 2 | | Anna | 1 | | Nanda | 1 | Could you help me with the formula I can use for this? ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [November 12, 2025, 6:25am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/14 "2025-11-12T06:25:04Z")
@ririsbars In this case, try the following formula. ```auto NonZero( Count( --filter parent level tickets from issue.subtask hierarchy Filter( DescendantsSet( [Issue.Sub-task].CurrentMember, [Issue.Sub-task].[Parent] ), --check if parents belong to page filters --return the sum of parent's children regardless of page filters ( [Measures].[Issues created], [Assignee].CurrentHierarchy.DefaultMember )>0 AND Sum( Childrenset([Issue.Sub-task].CurrentMember), -- Check if any sub-issue exists for the current Assignee context in the rows DefaultContext(( [Measures].[Issues created], [Assignee].CurrentHierarchyMember, [Issue.Sub-task].CurrentMember )) )>0 ) ) ) ``` Martins / eazyBI ---
**Author:** ![ririsbars](https://community.eazybi.com/user_avatar/community.eazybi.com/ririsbars/32/14742_2.png) [@ririsbars](https://community.eazybi.com/u/ririsbars)\ **Post date:** [November 13, 2025, 7:49am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/15 "2025-11-13T07:49:37Z")
Hello Martins, Thank you for helping with the formula. However, when I implemented it, the formula often consumed too much memory because it’s too complex, and no data was displayed. Do you have any recommendations for filtering so that the data can be displayed? ---
**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Post date:** [November 13, 2025, 8:02am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/16 "2025-11-13T08:02:18Z")
Hi @ririsbars Please export and send your report definition to [support@eazybi.com](mailto:support@eazybi.com) Here is how to export your definition > **[Export and import report definitions](https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions)** Martins / eazyBI support ---
**Author:** ![ririsbars](https://community.eazybi.com/user_avatar/community.eazybi.com/ririsbars/32/14742_2.png) [@ririsbars](https://community.eazybi.com/u/ririsbars)\ **Post date:** [November 13, 2025, 8:18am UTC](https://community.eazybi.com/t/how-to-get-all-the-assignee-of-issues-under-a-epic/3425/17 "2025-11-13T08:18:01Z")
Thanks Martins, I just sent the email, and I really hope for your help.