Forum Discussion
Counting ranks
Hi,
I have a table trying to count different attainments:
This is the table I have:
| Rank |
| >75% |
| >75% |
| >75% |
| 0%-25% |
| 0%-25% |
| 0%-25% |
| 0%-25% |
| 0%-25% |
| 0%-25% |
| 0%-25% |
| 0%-25% |
| 25%-50% |
| 25%-50% |
| 50%-75% |
| 50%-75% |
| 50%-75% |
| 50%-75% |
| 50%-75% |
| 50%-75% |
and this is the table I'm trying to get:
| Rank | >75% | 0%-25% | 25%-50% | 50%-75% |
| Count | 3 | 8 | 2 | 6 |
How do I create a measure to accomplish that?
Thank you Jihwan,
Unfortunately that would not work for me, as I have other columns too.
Example:
Category Achieved
A >75%
B >75%
C 0%-25%
D 0%-25%
E 0%-25%
F 25%-50%
H 50%-75%
So I need to speciafy the column within the table
Hi Thunders ,
Please use this DAX:Measure = CALCULATE( COUNTROWS('Table'), ALLEXCEPT( 'Table', 'Table'[Rank] ) )
If I add other columns:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi,
Please check the below picture and the attached pbix file.
COUNTROWS function (DAX) - DAX | Microsoft Learn
Count measure: = COUNTROWS('Table')Thank you Jihwan,
Unfortunately that would not work for me, as I have other columns too.
Example:
Category Achieved
A >75%
B >75%
C 0%-25%
D 0%-25%
E 0%-25%
F 25%-50%
H 50%-75%
So I need to speciafy the column within the table
Hi Thunders ,
Please use this DAX:Measure = CALCULATE( COUNTROWS('Table'), ALLEXCEPT( 'Table', 'Table'[Rank] ) )
If I add other columns:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
