Show highest value through Expression

[Anonymous]

Hello

I have found the percentages of certain values which I'm interested in

But I'm looking for an expressions to show the highest percentage based on a certain value in a KPI

i.e.

A = 10%

B = 20%

C = 5%

Show percentage of B

[akpofureenughwu]

Can you express this better?

[ishanbhatt]

Hello Michael,

Use below expression

=FirstSortedValue([Alphabet],-aggr(Max([Percentage]),[Alphabet]),1)

Please note that here I've given Alphabet and percentage field name of your data.

Hopefully, this will help you.