double RANKX ? HOW?

[Nick_Kalichava]

Hello, experts!

I need help with RANKX

In my table I rank groups by Quantity sold and by Amount sold. (So i have 2 rankings)

,

measure 1 -
Rank_by_quantity =

RANKX(

ALL(Table[GROUP]),

CALCULATE(COUNTA(Table[Quanity]))

)

measure 2 - 

Rank_by_amount =

RANKX(

ALL(Table[GROUP]),

CALCULATE(SUM(Table[AMOUNT]))

)

BUT

as you can see in the picture below there are 4 groups ranked 4 in quantity

The task is,

First I rank groups by quantity sold, but if the ranking is the same it should rank my an amount.

[pratyashasamal]

Hi @Nick_Kalichava ,
Try to use Dense in the Rankx function.
For example :-

Rank_by_quantity =

RANKX(

ALL(Table[GROUP]),

CALCULATE(COUNTA(Table[Quanity])) ,DESC,dense)

)
You can refer to this link .
https://learn.microsoft.com/en-us/dax/rankx-function-dax

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Nick_Kalichava]

Please,

read the description.
my task is to rank by 2 different ranks in one column.

[pratyashasamal · Accepted solution]

Hi @Nick_Kalichava ,
If you want to rank based on multiple column you follow this blog .
https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/
Hope this was helpful.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C