Distinct Issue Count

CarlyBooth · February 2, 2021, 10:04am

Hello,

We include Change Requests as part of our workflow and import ‘Approved changes resolved’ as a measure and ‘Issue Approved Changes’ as a property. An issue can have more than 1 change but i would like to count the distint issues that had approved changes i.e if an issue had 2 approved change requests then I would like to count it once.

Many Thanks
Carly

janis.plume · February 11, 2021, 9:37am

Hi,

The Count function should do that:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Approved changes resolved]>0
  )
))

Kindly,
Janis, eazyBI support