Forum Discussion
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 and zero values . I have created the following for measures to calculate that but it returns the subcategories count rather than a categories count. Please refer the attached images. Anyone please suggest me to find out.
+ve CategoriesCount = CALCULATE(COUNT('Sheet2 (2)'[Category]),'Sheet2 (2)'[Values] >0)
-ve CategoriesCount = CALCULATE(COUNT('Sheet2 (2)'[Category]),'Sheet2 (2)'[Values] <0)
zero CategoriesCount = CALCULATE(COUNT('Sheet2 (2)'[Category]),'Sheet2 (2)'[Values] =0)
Check if DISTINCTCOUNT Function works in your case.
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Category] ), Table1[Values] > 0 )
1 Reply
- v-chuncz-msft
Community Support
Check if DISTINCTCOUNT Function works in your case.
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Category] ), Table1[Values] > 0 )