topic Re: How to rank based on multiple parameters in DAX Commands and Tips

How to rank based on multiple parameters

Anonymouse — Sun, 06 Aug 2023 02:58:39 GMT

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

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!

Re: How to rank based on multiple parameters

ThxAlot — Sun, 06 Aug 2023 07:16:24 GMT

Rank ASC.pbix

A most common question about sorting in ascending order

Re: How to rank based on multiple parameters

Anonymous — Sun, 06 Aug 2023 07:39:45 GMT

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.

Re: How to rank based on multiple parameters

Anonymouse — Mon, 07 Aug 2023 05:07:53 GMT

Hi there,

when i tried your solution with sample data , my rank is all '1'. Could you kindly advise?