Forum Discussion
Solved
How to rank based on multiple parameters
Hi there, I would like to rank a dataset based on multiple paramenters. From:
| Product | Salesperson | Sales |
| Product A | Alan | 10 |
| Product B | Bob | 20 |
| Product B | Alan | 22 |
| Product A | Charlie | 11 |
to
| Product | Salesperson | Sales | Rank |
| Product A | Alan | 10 | 1 |
| Product A | Charlie | 11 | 2 |
| Product B | Bob | 20 | 1 |
| Product B | Alan | 22 | 2 |
Any ideas how to do this? Tried looking at RankX but it seems to be only for 1 paramenter only. Thanks!
3 Replies
- ThxAlot
Super User
Hi there,
when i tried your solution with sample data , my rank is all '1'. Could you kindly advise?
Please feel free to utilize either the "Rank" measure provided below or the "ThxAlot" measure, both of which yield accurate results.
Rank =RANK(DENSE,CALCULATETABLE(VALUES('Your Table Name'[Salesperson]),ALLSELECTED('Your Table Name'[Salesperson])),ORDERBY([sale],ASC))
If you find the solution to your problem using either of these measures, kindly mark the issue as resolved.
