Dynamic Top 100 Ranking with Field Parameter Breaks When Rating Column is in Visual

[ameyshar123]

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.

[v-veshwara-msft]

Hi @ameyshar123 ,

We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft · Accepted solution]

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.

[AntrikshSharma]

@ameyshar123 The Dynamic Rank part is indication that you need to use Calculation Groups and not Fields Parameters.

[parry2k]

@ameyshar123 can you share a sample PBIX file, using OneDrive/Google Drive, and remove any sensitive information before sharing.

[parry2k]

@ameyshar123 you have to add the rating column in the ALLSELECTED as well