Counting Epics in Project with missed target date

Questions & Answers
,
21

Sum(
Filter(
Descendants([Issue.Advanced Roadmaps].CurrentHierarchyMember,[Issue.Advanced Roadmaps].[Epic]),
[Measures].[Tageszaehler zwischen target start und review]>1
),
CASE WHEN
[Measures].[Issues with target start]>1
THEN
1
END
)

22

This code is not supposed to work with issue.epic hierarchy which you have in your report.

Try this one:

Sum(
Filter(
Descendants([Issue.Epic].CurrentHierarchyMember,[Issue.Epic].[Epic]),
[Measures].[Tageszaehler zwischen target start und review]>1
),
CASE WHEN
[Measures].[Issues with target start]>1
THEN
1
END
)

Martins

23

Also, make sure that you find “Issues with target start” measure in the “Measures” dimension

24

Hi Martins,

thank you very much. Now it is working and it calculates the amount of late epics in the entire Project.

Best regards
LeoDu

1 Like