Forum Discussion
double RANKX ? HOW?
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)
,
Rank_by_quantity =
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.
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
3 Replies
- pratyashasamal
Memorable Member
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-daxThanks,
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 CPlease,
read the description.
my task is to rank by 2 different ranks in one column.- pratyashasamal
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
