Forum Discussion
Solved
How can I use Sort by Column and RANKX at same time.
Hi all, I used RANKX to set up my Power BI report before. But today I got some problems when using RANKX and Sort by Column function at the same time. I really need you help, I really appreciate ...
bir1concepts , Try Rank like
test_r = RANKX(ALL(test[Product], test[Sort),CALCULATE(SUM(test[Qty])),,ASC)
Same way you can try for another measures
Thank amitchandak a lot, you saved my day ❤️