RANKX and tie breaker

[PowerRon]

Hi

I am using tie breaker for the first time but can't get it working.
Maybe someone can help.

https://www.dropbox.com/scl/fi/rtv3ghfv12g1vg7fp0vmt/test.pbix?rlkey=pipd1q7kysjmok758og3bmlsg&dl=0 

If you look at the table in the attached pbix you see 4 measures:

1. Sum Quantity. on which the table now is sorted (ascending)
2. RankSum. For Sum Quantity value 371 the ranking is equal, being 172
3. Rand
4. RankRand

In measure 4 I use measure 3. I thought by using this the Rank of Fatz Group would become 173 (instead of 172) and that of SHISEIDO Ltd would become 164 instead of 163.
But that's not happening. 
I also don;t know why the Rand of Fatz Group and Voonyx Group is still the same.

Can someone help me?

Regards
Ron

[Ashish_Mathur]

Hi,

I'd solve it with the RANK function

Measure = RANK(DENSE,SUMMARIZE(ALLSELECTED(Sales),Customers[Customer Names],"A",[Sum Quantity]),ORDERBY([A],desc,Customers[Customer Names],desc))

Hope this helps.

[MFelix · Accepted solution]

Hi @PowerRon ,

Try the following code:

RankSum = 
RANKX(ALLSELECTED('Customers'[Customer Names]),
[Sum Quantity]+CALCULATE( SUM(Customers[Customer Index])/100)
    
,,DESC)

[PowerRon]

Hi Miguel, thnx. It works. Why doesn't it work with RAND()? Any idea?

Regards
Ron

[MFelix]

Because when you use the rand has a measure the value gets recalculate and usually for the metric where you reusing the value its always the same so no difference.