Rankx ranking different value equally

[Anonymous]

Hi All,

I am trying to rank the most expensive assets by their location. I am using Rankx and I ahve used a various combination and the closest I got is this one (see table below) as you can see the column Ra Cost LV5 is ranking as 1 the first 2 numbers which are actually different. 

Actual total cost is simply column from the table and Ra Cost LV5 is

Ra Cost LV5 = RANKX(ALLSELECTED('Report 1'),CALCULATE(SUM('Report 1'[Actual Total Cost])),,DESC,Dense)

Anyone knows what I am doing wrong?

@mahoneypat

[v-easonf-msft]

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi， @Anonymous 

You can try the following code.

Ra Cost LV5 = RANKX(ALLSELECTED('Report 1'[LVL5_Description]),CALCULATE(SUM('Report 1'[Actual Total Cost])),,DESC,Dense)

 If  not correct, please provide a more detailed table model for testing.

Best Regards,
Community Support Team _ Eason

[Fowmy]

@Anonymous 

Your measure is fine, I am not sure how other filters applied in the report are affecting this ranking, try

Ra Cost LV5 = RANKX(ALL('Report 1'),CALCULATE(SUM('Report 1'[Actual Total Cost])),,DESC,Dense)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Anonymous]

Thanks for your help Fowmy

Unfortunately this is an option I have tried already but is not working.

It is probably starting from 14 because not is not considering the slicers anymore but still I ahve 2 deifferent value with the same ranking.