Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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 different measures right now with this.
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" )
)
| User | Count |
|---|---|
| 50 | |
| 39 | |
| 29 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 68 | |
| 57 | |
| 40 | |
| 22 | |
| 19 |