Forum Discussion
DISTINCT COUNT AND GROUP BY
Hello: I am trying to do GROUP BY in a DAX statement with DISTINCT COUNT. When I use this formula I get this: CALCULATE (DISTINCTCOUNT(Table_1[Dim_1]), FILTER(Table_1,Tabl...
Hi Anonymous ,
According to your statement, I still have some questions. I am confused about DISTINCTCOUNT YTD = 89, however DISTINCTCOUNT MONTH = 166. Please share a sample file with me and show me a screenshot with the result you want.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.