How to rank based on multiple parameters

[Anonymouse]

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!

[Anonymous]

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.

[ThxAlot · Accepted solution]

Rank ASC.pbix

A most common question about sorting in ascending order

[Anonymouse]

Hi there,

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