Forum Discussion
Distinct count two measures
How can I count distinct numbers within measures or variables. There are two ways I can do this combine at the measures into another measure or make one measure and create variables. I have 9 differe...
You can write a totaling measure that takes into account all the flags. || = OR in DAX so something like this.
Total Count =
CALCULATE (
DISTINCTCOUNT ( '999_Funnel'[OLI Number] ),
'999_Funnel'[OLI.Status] = "Active" &&
( '999_Funnel'[FC (Flag)] = "Y" || '999_Funnel'[Another (Flag)] = "Y" )
)