Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :
Solved! Go to Solution.
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.
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 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.
In your fromual what is [EachesCost] ?
Sorry for the inclmplete data..
DC-R Ace is the table,
[Eachescost] is the Sales$ column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |