Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |