Rankx with mutiple column in table and multiple slicers

[JStaf]

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. 

Any help/tips are appreciated.  thank you

[MisterFry]

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.