Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
A most common question about sorting in ascending order
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Please feel free to utilize either the "Rank" measure provided below or the "ThxAlot" measure, both of which yield accurate results.
A most common question about sorting in ascending order
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Hi there,
when i tried your solution with sample data , my rank is all '1'. Could you kindly advise?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |