Forum Discussion
Solved
Measure to count the categories based on values
I have a category and subcategory which has combination +ve , -ve and 0 values . I would like to create a mesure to calculate the number of categoies ( rows count) which has a positive , negative...
Check if DISTINCTCOUNT Function works in your case.
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Category] ), Table1[Values] > 0 )
v-chuncz-msft
Community Support
Community Support
Check if DISTINCTCOUNT Function works in your case.
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Category] ), Table1[Values] > 0 )