Counting ranks

[Thunders]

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?

[Thunders · Accepted solution]

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

[Thunders · Accepted solution]

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

[Anonymous · Accepted solution]

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.

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

COUNTROWS function (DAX) - DAX | Microsoft Learn

Count measure: = 
COUNTROWS('Table')