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 that.
This is my test data, Product is sort by Product as normal
These are 2 measures to test data:
test_c = CONCATENATEX(ALL(test[Product]),CALCULATE(SUM(test[Qty])),,",",ASC)
test_r = RANKX(ALL(test[Product]),CALCULATE(SUM(test[Qty])),,ASC)
The result looks well. But I want to sort Product by column "Sort"
After that when I come back to my 2 measures, it's give wrong number. I dont know why?
I did research a lot around to this problem, but I still did not get the answer. Did anyone get into this situation before, how can I solve this problem?
Thank you all
Go to Solution.
@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
Proud to be a Super User!
View solution in original post
Thank @amitchandak a lot, you saved my day ❤️
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!