RANKX

[ibuhary]

Hello there,

I have a table with Store ID, Store Name and Sales.

I have created a measure to Rank the Store Names based on highest sales.

StoreRank = RANKX(ALLSELECTED(
'Table'[Store Name]),
CALCULATE(SUM('Table'[Sales])),,DESC)

When I use the Rank alone with Store Name it works, but the moment I add store ID in the table it returns all ranks to - 1

Can anyone help me solve this issue, please.

[sokg]

Why do you use ALLSELECTED instead of ALL???

Why do you use 'Table'[Store Name] instead of just 'Table'???

so try this

StoreRank =
RANKX ( ALL ( Table ), CALCULATE ( SUM ( 'Table'[Sales] ) ),, DESC )

[ibuhary]

In that case the ranks returned are all 1 for all the stores

[sokg · Accepted solution]

Not in my test data. See pic below

[ibuhary]

Actually I have a larger database, but I cut it short to ask the question.

Is it possible to send it to you to check what I am doing wrong ?

[sokg]

Yes, my email is sokg@yahoo.com. You can send me your .pbix file.

Please check your privacy of your data. I assume you are allowed to do that.

[ibuhary]

I have sent you the file in your email

[ibuhary]

Hi, Have you been able to check my file.

[sokg]

I have not receive it.

Please send it again

sokg@yahoo.com

[ibuhary]

Please check, I sent again now.

[Anonymous]

Did you ever get a response? I have the same issue.