topic Re: Dynamic Top 100 Ranking with Field Parameter Breaks When Rating Column is in Visual in DAX Commands and Tips

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

ameyshar123 — Tue, 14 Apr 2026 15:26:30 GMT

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.

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

parry2k — Tue, 14 Apr 2026 14:58:26 GMT

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

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

parry2k — Tue, 14 Apr 2026 15:09:07 GMT

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

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

AntrikshSharma — Wed, 15 Apr 2026 07:26:54 GMT

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

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

v-veshwara-msft — Mon, 20 Apr 2026 04:33:52 GMT

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.

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

v-veshwara-msft — Fri, 24 Apr 2026 04:00:55 GMT

Hi ameyshar123 ,

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