Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
Solved! Go to Solution.
Check if DISTINCTCOUNT Function works in your case.
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Category] ), Table1[Values] > 0 )
Check if DISTINCTCOUNT Function works in your case.
Measure = CALCULATE ( DISTINCTCOUNT ( Table1[Category] ), Table1[Values] > 0 )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |