RANKX avoid duplicate

@Toni Don’t use RAND for breaking ties. PERIOD.

Refer to this:

Ranking (Breaking Ties) for a Category based on a Measure with duplicate values for categories - DAX Calculations - Enterprise DNA Forum

and this by @BrianJ :

Developing Custom Tiebreakers in RANKX - DAX Tutorial - YouTube

2 Likes