Forum Discussion
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 | CustomerName | Sales$ | Rank |
| 16290 | A | 430234 | 1 |
| 3874 | B | 428866 | 1 |
| 16364 | C | 364207 | 1 |
| 14920 | D | 364207 | 1 |
I am expecting something like below.
| CustomerNumber | CustomerName | Sales$ | Rank |
| 16290 | A | 430234 | 1 |
| 3874 | B | 428866 | 2 |
| 16364 | C | 364207 | 3 |
| 14920 | D | 364207 | 4 |
I used this :
Rank = RANKX(ALL('DC-R Ace'[CustomerNumber]),CALCULATE(SUM('DC-R Ace'[EachesCost])),,DESC)
Where am I doing wrong. Please help.
Thanks
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 JainDo Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
4 Replies
AnkitBISolution Sage
In your fromual what is [EachesCost] ?
- AnkitBI
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 JainDo Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
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.