Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 )
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |