Possible use of DISTINCT for multiple measures

Questions & Answers
1

Hello all,
I have 2 distinct measures. One measure count a change in the issue and another counts a change from one issue type to another. Often in the same week, a single issue can have meet both situations, causing the summed count to be 2 instead of 1 for that issue.
Can the MDX function DISTINCT be used to filter out this situation?

2

Hi,

The Distinct function can be used over a set, not for filtering members of the set with different conditions. The solution here would be to implement your custom calculation with the Descendants function to filter the set of distinct issues. The formula would be like this:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Measure 1]>0 OR
    [Measures].[Measure 2]>0
  )
))

Kindly,
Janis, eazyBI support