Forum Discussion
RankX Measure re-calculating in table when filtering?
Having spent a long time invesigating, it appears that the measure works with just "Product code" and the addition of "product code + product scheme" is what breaks it! Suggestign the measure was fine and the underlying data contains the issue. To combat this, I've created a hierachy with product code -> product scheme, which allows us to still see the scheme attached to the code after a simple drill through click!
Hi Jordan,
I believe the measure is being filtered when you filter the results. The way to avoid this would be to specifiy in the calculate part of your measure that you want it to be for all data in your table
Prod ADV % Rank = RANKX(ALL('Pols Outcome and Inception'[Product Code + Scheme fin]),CALCULATE([ADV%]),All('Pols Outcome and Inception'))