Forum Discussion

ameyshar123's avatar
ameyshar123
New Member
4 months ago
Solved

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)

AppleAAA501
MicrosoftAAA452
TeslaAA401
AppleAA302

Expected Result:

COMPANY RATING RISKCONTB Rank (CORRECT)

AppleAAA501
AppleAA303
MicrosoftAAA452
MicrosoftBBB254

I need the rank to stay consistent per company regardless of the Rating row, while still allowing dynamic measure switching via the Field Parameter.

5 Replies