Forum Discussion
liliachante
6 years agoFrequent Visitor
Unique value for a rank
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
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-measuresBest Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
1 Reply
- MariuszCommunity Champion
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-measuresBest Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.