- 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
RANKX Expression for 3 Columns
Hi everyone, first post. Using the sample data below (call the table RANKX Test), I want to write a RANKX measure that ranks the Attribute column by the Value column, for each ID column value:
ID | Attribute | Value |
111 | A | 60 |
111 | B | 50 |
112 | A | 50 |
112 | B | 70 |
113 | A | 20 |
113 | B | 40 |
I know how to rank attribute by value, and create a visual level filter for the top ranked attribute:
Rank Attributes = IF(RANKX(ALLSELECTED('RANKX Test'[Attribute]),CALCULATE(SUM('RANKX Test'[Value])),,ASC,Dense)
<=1,1,0)
A table with the Attribute column and a column with the COUNT of Attribute values looks like this:
Attribute Count of Attribute
A 3
I need to add the ID column to the measure, so that the attributes are ranked for each ID. I would want the table above to look like this since A would be the top ranked attribute for two IDs and B would be the top ranked attribute for one ID:
Attribute Count of Attribute
A 2
B 1
Appreciate any help on this!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.
Count of attribute expected result: =
VAR _currentrowattribute =
MAX ( Data[Attribute] )
RETURN
IF (
HASONEVALUE ( Data[Attribute] ),
COUNTROWS (
FILTER (
ADDCOLUMNS (
ALL ( Data ),
"@Rank_partion_ID",
RANK (
skip,
ALL ( Data ),
ORDERBY ( Data[Value], ASC ),
PARTITIONBY ( Data[ID] )
)
),
Data[Attribute] = _currentrowattribute
&& [@Rank_partion_ID] = 1
)
)
)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.
Count of attribute expected result: =
VAR _currentrowattribute =
MAX ( Data[Attribute] )
RETURN
IF (
HASONEVALUE ( Data[Attribute] ),
COUNTROWS (
FILTER (
ADDCOLUMNS (
ALL ( Data ),
"@Rank_partion_ID",
RANK (
skip,
ALL ( Data ),
ORDERBY ( Data[Value], ASC ),
PARTITIONBY ( Data[ID] )
)
),
Data[Attribute] = _currentrowattribute
&& [@Rank_partion_ID] = 1
)
)
)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks! That works...

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
05-15-2025 01:17 PM | |||
05-01-2025 11:13 PM | |||
04-25-2025 12:44 PM | |||
05-22-2025 02:16 AM | |||
Anonymous
| 11-16-2021 05:11 AM |
User | Count |
---|---|
10 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
17 | |
14 | |
11 | |
9 | |
7 |