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))
