Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
JStaf
Frequent Visitor

Rankx with mutiple column in table and multiple slicers

Hi,

I am trying to calculate rank on the table visual that has multiple slicers on it.  When the table has 1 column, rank appears correctly (pic 1).  However, when I start adding another column to the table (the second column adding is just a description of the first column so it's 1 to 1), ranking is not correct anymore (like pic 2).  What I want is to have pic 2 have correct rank like pic 1. 

 

Capture.PNGAny help/tips are appreciated.  thank you

1 REPLY 1
MisterFry
Resolver III
Resolver III

Good ol' RANKX... 

 

Getting a hold of why RANKX is doing this is complicated and involves some knowledge of row contexts, which is a core principle of the DAX language. 
This does a pretty good job explaining it: 
https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/

 

The short answer is that you need to ignore ALL of the fields in your visual to get RANKX to return the right value. Add them to your ALL() statement, and it should work. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.