Forum Discussion
Distinct count subtotal
Hello All I am a newbie to Dax !, The answer to my query is likely very simple I have performed a distinct count on all values in a column which are higher than zero However, the p...
Hi amitchandak
How would you write this into the measure? , currentlu the measure is CALCULATE(DISTINCTCOUNT(Table1[Forecast Reviewed]),FILTER(Table1,[Forecast Reviewed]>0))
I am not sure on the values in [Forecast Reviewed], based on the values it can sum, count distinct or we need to take count distinct of name
CALCULATE(sum(Table1[Forecast Reviewed]),FILTER(Table1,[Forecast Reviewed]>0))
CALCULATE(DISTINCTCOUNT(Name]),FILTER(Table1,[Forecast Reviewed]>0))