Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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
Solved! 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |