DAX - correct use of RANKX

[Mike_R_]

Dear Colleagues,
I wanted to practice with DAX but I got stuck incorrectly working RANKX function.
I worked on adventureworks data, Person_person table.
In 3rd column of upper table I counted occurances of persontype.
In next colummn I wanted to create a ranking using RankX function, therefore I created new measure as per attached printscreen (ranking = rankx('Person Person',count('Person Person'[PersonType]),,,Dense).
However a result of such ranking is 1 (last column in table)!
Can you please advise on how to fix the issue? I supose I need to modify DAX function...

Thanks in advance for help and reply!

Mike

 

[Matt Allington]

When using RANKX, you are ranking an individual against all others. But the first parameter (the table) also receives the filter from the visual. So you have to first remove the filter. So wrap the first parameter inside ALL, like RANKX(ALL(person), etc

 

[Mike_R_]

Thanks very much for information Matt. However after applying ALL prior to table, it did not change anything (still I have 1 everywhere).
Maybe I need to apply ALL also while having count function in 2nd parameter....
Can you please advise?