Forum Discussion

liliachante's avatar
liliachante
Frequent Visitor
6 years ago
Solved

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