Forum Discussion
Distinct count subtotal
Number of Forecasters Who Input is the number field of the name field. Because if it is a number field the distinct count of number is happening.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi amitchandak
Thank you for replying
I have used a measure to get the distinct count , i tried changing the original columns format to general but the measures subtotal still shows only 1 ?
One top of count distinct, you need to have sum. In case it is number use base column to get distinct count
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))