I have a dataset which captures response of a question in 3 different columns. 1st column being the 1st preferred destination/country and 3rd column being the 3rd preferred destination/country. I have unpivoted the 3 columns to capture responses of 3 different columns in 1 column. I have assigned weighted score to responses of different columns (1st preferred - 5, 2nd preferred - 3, 3rd preferred -1). I want to show top 10 countries for preferred destination basis the weighted score. I have used the Top N filter to show top 10 items basis weighted score. I have multiple filters (Region, Country, Sector). It displays top 10 countries for most of the filter scenarios. But there are instances where it displays more than 10 countries. This is because of the same weighted score of the countries within top 10.
Please help me in resolving the issue to populate 1st top 10 countries even if the weighted score is same.
Solved! Go to Solution.
@JagdeepPS , I think you need Rank tie breaker
Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-...
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
@JagdeepPS , I think you need Rank tie breaker
Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-...
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
401 | |
107 | |
68 | |
56 | |
49 |
User | Count |
---|---|
373 | |
121 | |
79 | |
67 | |
57 |