How to count no.of issues with particular value for a calculated measure

Questions & Answers
1

Hi Team,

I have created a calculated member, ‘Compare Epic status with children’, that compares my Epic status with its child issues and gives the result as ‘true/false’. Now I need a report to show how many issues have a ‘true’ value for my custom measure ‘Compare Epic status with children’ and how many issues have a ‘false’ value for the same. Please help me to achieve this.

Thanks!
Pooja

Screenshot 2024-06-04 135714
Screenshot 2024-06-04 1357141079×142 6.05 KB

2

Hi @Pooja_Sree

Welcome to the Community! :sunny:

If you wish to count the number of “true” results, you’ll need to usa a higher level in the report, for example, the “All Issues by Epic” member or other dimension members, like, Project/Assignee/etc dimension members.
With this, you can use a formula like this:

Count(
  Filter(
    Descendants([Issue.Epic].CurrentMember,[Issue.Epic].[Epic]),
    -- your existing formula here
  )
)

It may need some adjustments based on your existing formula, so if it’s not working as expected, please share the formula that you currently use and what is the level at which you would like to display this sum.

​Best regards,
​Nauris

3

Hi @nauris.malitis,

I 'm using this formula to compare epics and its child issues(cross project child issues).

CASE WHEN
 [Issue].CurrentHierarchyMember.Level.Name="Epic"
 THEN

CASE WHEN [Measures].[Issue status]="To Do" --epic status todop
THEN --must be at least one story in To Do
  CoalesceEmpty(([Measures].[Issues created],
   [Status].[To Do],
   [Issue Type].[Story]),0)>=0
 WHEN [Measures].[Issue status]="Done" --epic status done
  
  THEN -- all stories are Done
  Count([Issue.Epic].CurrentHierarchyMember.Children)=
  CoalesceEmpty(([Measures].[Issues created],
   [Status].[Done],
   [Issue Type].[Story]) ,0)
END

END

And I need the count at epic level.

Thanks!!