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.
Hello guys, Im newbie here, Im searching for a while for this solution but I cant help myself.
Ive used this tutorial for making a pareto diagram https://powerbi.tips/2016/10/pareto-charting/ , but I have 4 slicers instead of 2 like in this tutorial. I have problem with RankX function beacuse when I use it like this
Ranking = RANKX( 'Summary', 'Summary'[Sum Sales])
and change the slicers I get good ranking order but it keeps giving me ranking from global. So when I change slicers I get something like this
Items Model Ranking
Item 1 Model 1 5
Item 2 Model 3 8
Item 3 Model 5 13
instead of 1,2,3. Can someone help me with this measure ? Ive tried it with AllExpect or with SUMX,SUM and different kind of variation and usually I got the same ranking as before or just ranking where every column returned 1.
Solved! Go to Solution.
I think this post will help:
https://community.powerbi.com/t5/Desktop/Ranking-Cumulative-Total/m-p/561983#M265151
@Anonymous,
Here is another example.
https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491
@Anonymous,
Here is another example.
https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491
I think this post will help:
https://community.powerbi.com/t5/Desktop/Ranking-Cumulative-Total/m-p/561983#M265151
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |