Unique value for a rank

[liliachante]

Hi,

I need a unique value for a ranking measure, but as my column has the same value ,the index doesn't increment. I Have two columns: 

Fruit and Fruit_Number. I create a measure totalFruit where I calculate a sum:

TotalFruit = SUM(Fruit[Fruit_Number])

Then I create a rank : 

Rank = RANKX(ALLSELECTED(Fruit);Fruit[TotalFruit];;DESC;Dense)

as Apricot and lemon have the same number 8, the value of the rank is 2 for each of them. I need 2 and 3 instead of having two 2; It's work with column but I don't want to use column . I need Measure.

Thank you in advance for your help.

Lilia

[Mariusz · Accepted solution]

Hi @liliachante 

Try the below article -  "Breaking Ties" section is what you need.
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.