Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RankX return many 1s

Hello all,   Iam trying to rank the customerNumber based on the sales. Top sales as 1 and next as 2 and so on .. But I get lot of rank values as 1.    This is how I am getting. CustomerNumber...
Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago

    For your case, Use below

     

    Rank = RANKX(ALL('DC-R Ace'[CustomerNumber],'DC-R Ace'[CustomerName]),CALCULATE(SUM('DC-R Ace'[Sales$])),,DESC)

    Thanks
    Ankit Jain

    Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

AnkitBI's avatar
AnkitBI
Icon for Solution Sage rankSolution Sage
6 years ago

For your case, Use below

 

Rank = RANKX(ALL('DC-R Ace'[CustomerNumber],'DC-R Ace'[CustomerName]),CALCULATE(SUM('DC-R Ace'[Sales$])),,DESC)

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

AnkitBI  Thanks a ton for the help.
I ve realized that We are supposed to add all the columns to the DAX formula that we are adding on to the visual.