Create Filter according to created "measure"

Questions & Answers
1

Hi,
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?

image
image3342×117 16.4 KB

2

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
    )
  )
)

best,
Gerda // support@eazybi.com

1 Like