Forum Discussion

prashant21's avatar
prashant21
New Member
3 years ago
Solved

Help with RANkX Function

 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.

 

 


 

 

Need Help

4 Replies

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    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's avatar
    prashant21
    New Member
    3 years ago

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

    • mlsx4's avatar
      mlsx4
      Memorable Member
      3 years ago

      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
)