Rankx with ties

[Chrisjr]

Hello All, 

I have a ranking issue I can't solve. 

I have the below table: 

1 same group can have multiple dealers. 

My ranking formula is  the following: 

ranking test = IF(NOT (ISBLANK([Score in %])),CALCULATE(RANKX(ALLSELECTED(Lookup__Dealer), [Score in %], , DESC)), BLANK())

This works well. However, when I add the Region  column (coming from a separate dim table), it gives me ties:

Suddenly, the dealer who was number 1 became number 2 and the number 2 and 3 both became number 3. Therefore, if in my slicer I select bottom 1, it will show me blank value.

I need the bottom 1 to remain 1 when I add the Region column like as below:

N Group	Dealer Full Name	Ranking test	score in %	Region
125	.......7	3	71,11	FR
573	.......6	2	62,22	NL
573	........2	1	49,44	NL

And If I select the Region NL in a slicer, I need my ranking to adapt iself as below:

N Group	Dealer Full Name	Ranking test	score in %	Region
573	.......6	2	62,22	NL
573	........2	1	49,44	NL

How could I achive this ?

Thanks

[talespin]

hi @Chrisjr 

Please try something like this, correct the table/column names. If it doesn't work, please share sample data, few rows from tables involved in this visual(remove any sensitive information).

RANK( DENSE, ALLSELECTED(Lookup__Dealer), ORDERBY( [Score in %], DESC))