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.
Hey Guys,
I have created a Rank function with a Top/Bottom filter. It's working, but it is acting kinda weird. Please see the attached image does anybody know why is that or what's wrong? It's showing the same rank even though they are not the same numbers that we rank by.
Equation -
Rank = IF( HASONEVALUE('Top/Bottom'[Order]), SWITCH( VALUES('Top/Bottom'[Order]), "Top 10", RANKX(ALL(Store_dim[StoreName]),[GP per Customer],,DESC,Dense), RANKX(ALL(Store_dim[StoreName]),[GP per Customer],,ASC,Dense) ))
This is a very large file. I try to upload a sample file but it did not work. Sorry about that.
One more thing, when I filter by Rank is less than 16, that is when my chart get weird
Thank you so much
Solved! Go to Solution.
Hi @Anonymous,
Please modify the formula to below for a test.
Rank = IF( HASONEVALUE('Top/Bottom'[Order]), SWITCH( VALUES('Top/Bottom'[Order]), "Top 10", RANKX(ALLSELECTED(Store_dim),[GP per Customer],,DESC,Dense), RANKX(ALLSELECTED(Store_dim),[GP per Customer],,ASC,Dense) ))
Regards,
Yuliana Gu
Hi @Anonymous,
Please modify the formula to below for a test.
Rank = IF( HASONEVALUE('Top/Bottom'[Order]), SWITCH( VALUES('Top/Bottom'[Order]), "Top 10", RANKX(ALLSELECTED(Store_dim),[GP per Customer],,DESC,Dense), RANKX(ALLSELECTED(Store_dim),[GP per Customer],,ASC,Dense) ))
Regards,
Yuliana Gu
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |