Ranking by two Measure Value

[Anonymous]

Hi All,

I have following Dataset. By using Sales & Unit measure i want to create Rank the customer  

Date	Company	Product	Sales	Unit
12/1/2019	C1	P1	10	2
12/2/2019	C1	P2	10	4
12/3/2019	C1	P1	10	6
12/4/2019	C2	P2	10	2
12/1/2019	C2	P1	10	2
12/2/2019	C2	P2	10	2
12/3/2019	C3	P1	5	3
12/4/2019	C3	P2	5	3
12/1/2019	C4	P1	5	3
12/2/2019	C4	P2	5	3
12/3/2019	C5	P1	7	2
12/4/2019	C5	P2	8	5

primarily i want to rank by sales. If two customer has same sales value we need to consider Unit Value

If Sales and Unit is same i want to rank Randomly (Same Value has different Rank )

[Ashish_Mathur · Accepted solution]

Hi,

I have been able to get the following:

Revenue = SUM(Data[Sales])

Units = SUM(Data[Unit])

Revenue and units = [Revenue]+([Units]/1000)

Rank = RANKX(ALL(Data[Company]),[Revenue and units])

However this returns the same rank where sales and units are the same.

[mwegener]

Hi @Anonymous ,

look at this.

https://community.powerbi.com/t5/Desktop/How-to-Rank-a-list-based-on-2-values-double-rankX/td-p/44008

PBIX

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.