How to Rank 2 measure

[kanchanaporn]

How to Rank 2 measure

Rank by units first then if units is equal >> rank by sales 

i use like this not work!!
Aggr(Num(Rank(Sum(Units),Sum(Sales)), name)

please help..

[TauseefKhan · Accepted solution]

Hi @kanchanaporn,

Required Result:     

Use this:
=Aggr(
Rank(
Sum(Unit) * 1000000 + Sum(Sales)
),
Name
)

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***

[kanchanaporn · Accepted solution]

it try found if same units and sales show like this 

[kanchanaporn · Accepted solution]

i use this it work!!!   thank you for you help

Aggr(Rank(Sum(Unit) * 1000000 + Sum(Sales),4,1),Name)