We have created a calculated measure (basically summing all the custom fields in Jira). We would like to create a filter according to the number. Sample, a filter which will only shows issues with “27” total Priority score. Is this possible?
Hi @Jim ,
You can create a calculated measure that counts only issues that have issues with score 27 using this formula:
NonZero( Count( Filter( DescendantsSet([Issue].CurrentMember, [Issue].[Issue]), [Measures].[YOUR FIELD PROPERTY] = 27 AND [Measures].[Issues created] > 0 ) ) )
Gerda // email@example.com