Forum Discussion
Dynamic Top 100 Ranking with Field Parameter Breaks When Rating Column is in Visual
Hi,
I have a measure that dynamically ranks companies in the Top 100 using a Field Parameter to let users switch between RISKCONTB and BV. The ranking uses RANKX with ALLSELECTED on Company, Subsector, and Country.
Problem:
When I add the RATING column to my visual, the ranking breaks. Instead of showing one consistent rank per company (based on total value), the rank resets per Rating group. For example:
COMPANY RATING RISKCONTB Rank (WRONG)
| Apple | AAA | 50 | 1 |
| Microsoft | AAA | 45 | 2 |
| Tesla | AA | 40 | 1 |
| Apple | AA | 30 | 2 |
Expected Result:
COMPANY RATING RISKCONTB Rank (CORRECT)
| Apple | AAA | 50 | 1 |
| Apple | AA | 30 | 3 |
| Microsoft | AAA | 45 | 2 |
| Microsoft | BBB | 25 | 4 |
I need the rank to stay consistent per company regardless of the Rating row, while still allowing dynamic measure switching via the Field Parameter.
Hi ameyshar123 ,
Thanks for reaching out to Microsoft Fabric Community.Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Also to assist better, could you share sample data or sample .pbix file without any sensitive information. You can upload your files to any cloud storage like OneDrive or GoogleDrive and paste the link here with appropriate permissions.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thank you.
5 Replies
- parry2kSuper User
ameyshar123 you have to add the rating column in the ALLSELECTED as well
- parry2kSuper User
ameyshar123 can you share a sample PBIX file, using OneDrive/Google Drive, and remove any sensitive information before sharing.
- AntrikshSharmaCommunity Champion
ameyshar123 The Dynamic Rank part is indication that you need to use Calculation Groups and not Fields Parameters.
- v-veshwara-msftCommunity Support
Hi ameyshar123 ,
Thanks for reaching out to Microsoft Fabric Community.Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Also to assist better, could you share sample data or sample .pbix file without any sensitive information. You can upload your files to any cloud storage like OneDrive or GoogleDrive and paste the link here with appropriate permissions.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thank you. - v-veshwara-msftCommunity Support
Hi ameyshar123 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.