TOPN without changing the data

[wooand]

Hello.

I have a column of Brokers that I need to rank by volume.  Easy enough.  I then need to show the top 5 only, but retain the percentages as per the original calculation, rather than calculating the percentages based on the filtered universe.    Can anyone help me please?  Please see the attached screenshot.  Essentially I would like the TOPN %GT filtered values in the visualisation on the right to be the same as the one on the left!

Thank you in advance.

[Datatouille · Accepted solution]

Hi,

I guess you applied a Top 5 visual-level filter on [USD Amount] for your matrix on the right.

Try the following measures:

Total Amt = Sum( YourTable[USD Amount] )

Pct GT USD Amount = Divide ( [Total Amount] , Calculate( [Total Amt] , All(YourTable[Counter-Party] ) )

Format Pct GT USD Amount as % and use to replace your current % measure on your matrix on the right.

[wooand]

Spot on.  Very kind of you, and many thanks.