Ranking measure needs expert opinion

[AlexDias]

Hello everyone,

I'm getting some wierd values which I can't understand and they aren't what I was expecting to get.

I have a calculated column based in this formula:

Sales (EUR) = Sales[Amount]/ Sales[RATE EUR-USD] 

And my measures are:

Total Revenue = SUM(Sales[Sales (EUR)])
Rank ASC = RANKX(ALL(Sales);[Total Revenue];;ASC)
Rank DESC = RANKX(ALL(Sales);[Total Revenue];;DESC)

I can't understand the the ranking values, I was expecting to get sequencial numbers from 1 to 7 and 7 to 1 as I only got 7 different clients at my table data.

I can't figure what I'm doing wrong.

[AlexDias · Accepted solution]

Problem solved, I was using the table to calc the rank and not the firld that iIactualy was expecting to be ranked.

Solved using:

Rank ASC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;ASC)
Rank DESC = RANKX(ALLSELECTED(Sales[Client Name]);[Total Revenue];;DESC)

But please, if anyone has a better idea please tell.