Help with RANkX Function

[prashant21]

 I am trying to write the DAX to get a ranking of stores based on sales. The code provided calculates the rank of stores based on their total weekly deals in the 'sales data-set'. But i am geting the same rank (rank 1) for all rows below is the code:-

Rank of Stores =

RANKX

(

ALL('sales data-set'), -- Replace 'Stores' with the appropriate table name

[Sum of Weekly Sales],

,DESC

,Dense

)

I am trying to get the ranking I can use to do TOP N analysis where N is coming from the parameter.

[prashant21]

Hi@mlsx4, Could you please let me know why it was necessary to add  'sales data-set'[Store] instead of 'sales data-set'?

[mlsx4]

Oh, I have used ALLSELECTED instead of ALL (It was a try). 
I have seen that it doesn't work. What have you written in the measure [Sum of weekly..]?

It is something silly but using dummy data it works...can you try to do this?

Rank of Stores =
RANKX
(
ALL('sales data-set'), -- Replace 'Stores' with the appropriate table name
CALCULATE (SUM ('sales data-set'[column])),
,DESC
,Dense
)

[mlsx4]

Hi @prashant21 

Try with:

Rank of Stores =
RANKX
(
ALLSELECTED('sales data-set'[Store]), -- Replace 'Stores' with the appropriate table name
[Sum of Weekly Sales],
,DESC
,Dense
)

[prashant21 · Accepted solution]

Hi, Still getting the same issue