Forum Discussion
Measure for distinct count based on value from another column
I have the following dataset and I am trying to get the unique value from Name column where the value in Status column is 3 and value not 0 or 2. So the result should be only D. Any help is greatly ...
MattAllington
Community Champion
Community ChampionIn DAX, you First filter, then calculate. Inside the calculate function, the first parameter is executed last. So.
=CALCULATE(distinctcount(tablename[name]),tablename[status]=3)
the filter is applied first (last parameter), then the calculation is executed