- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please check the below picture and the attached pbix file.
COUNTROWS function (DAX) - DAX | Microsoft Learn
Count measure: =
COUNTROWS('Table')
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Click here to visit my LinkedIn page
Click here to schedule a short Teams meeting to discuss your question.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-03-2025 12:15 PM | |||
01-13-2025 02:52 AM | |||
06-05-2025 03:49 PM | |||
05-21-2025 12:01 AM | |||
01-18-2023 04:57 PM |
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |