Forum Discussion

LauraE's avatar
LauraE
Regular Visitor
2 years ago

Ranking when multiple numeric values repeats in a column

Hello all,    I am relatively new to Power BI and are struggling to find the correct DAX code (or solution in general) to my ranking problem. To set some background, I am working with a huge datase...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi LauraE ,

 

I have a workaround, you can try using rankx sorting and with the help of ID, which avoids duplicate values:

 

Rank =
RANKX(
    ALL('Table'),
    'Table'[Your sort measure] + (0.1 / 'Table'[ID]),
    ,
    DESC
)

 

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.