Forum Discussion
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...
Hi, Still getting the same issue
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
)Hi, Still getting the same issue