RANKX measure with ignoring some category

[Cardi0z]

i'm trying to use RANKX measure to set rank on my power bi report. but i have some problem (see screenshoot), any body can help me, how to fix that issue?

[talespin · Accepted solution]

hi @Cardi0z 

In first table visual I have used ALL(Rank) and in second I have used ALLSELECTED(Rank), this will honour filters from the filter panel. Hope this helps.

Rank = RANK( DENSE, ALL('Rank') , ORDERBY('Rank'[Points], DESC), FIRST)

Rank = RANK( DENSE, ALLSELECTED('Rank') , ORDERBY('Rank'[Points], DESC), FIRST)