Count issues per epic including child issues on all levels

Questions & Answers
1

Hi,
I want to count all issues in an epic. Issues have child issues on several levels. I want to count them all. How do I do this?
I do not have the option to create a calculated dimension as I do not have system admin rights.

2

[Issue].CurrentHierarchyMember.Children gives me the number of children, but those children do also have children. How can I fetch those?

3

I did a calculated measure as follows:

This lets me see al the tasks under the initiative.

Aggregate(

[plans Initiative]. [issue number], (what ever that may be)

[measures].[open issues only]

)

Cheers

Dave

4

Hello Annette,

If you have a standard Epic hierarchy and the “Epic” hierarchy level only contains issues with issue type “Epic“, you might use the [Issue.Epic] hierarchy on report rows and then use the following calculation.

CASE WHEN
-- any isues relevant other than context
 [Measures].[Issues created]>0
THEN
-- show number of relevant issues
 [Measures].[Issues created]
-
-- subtract the Epic itself
 ([Measures].[Issues created],
  [Issue Type].[Epic])
END

Regards,

Oskars / support@eazyBI.com