Forum Discussion
Getting different totals for Count and Distinct Count which is not grouped by Function prop
Hi, I expecting a solution for the following On the left, the total 64 is the sum of the item title. On the right the measure is the distinct count of the item title. While analysing i...
Hi Anonymous ,
Is your requirement for the number of specific item types in each month? You can create a calculated column to classify item categories, and then calculate the total number of categories.
Column = CALCULATE(COUNTROWS(Table2),ALLEXCEPT(Table2,Table2[Item Title]))
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.