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
Solution Sage
6 years ago

In your fromual what is [EachesCost] ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Sorry for the inclmplete data..
    DC-R Ace is the table,
    [Eachescost] is the Sales$ column.