Distinct count for Issue History

Questions & Answers
,
2

Hi @Cosmina,

It seems my colleague Lauma already answered your inquiry in an internal conversation. Here is the proposed formula for all community members to see:

NonZero(Count(
  Filter(
    --go through individual issues 
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    IIF([Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember,
      --if no period selected show distinct count of issues matching selected values
      CAST([Measures].[Transitions to issues count] AS NUMERIC),
      --count issues that had selected values at the end of period
      DateBeforePeriodEnd(
        [Issue].CurrentHierarchyMember.Get('Created at'),
        [Time].CurrentHierarchyMember)
      AND
       [Measures].[Issues history] > 0
    )
)))

Best,
Roberts // support@eazybi.com

2 Likes