Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you express this better?
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.