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
A = 10%
B = 20%
C = 5%
Show percentage of B
Have you tried the max function ?
Forgot to say that the values are in created in different measures
They are not in the dataset
then RangeMax() function?
if no could you share the example?
I have 3 measures A,B,C
I am looking for a way to show the Max of these three measures
I've tried to enter the code for each measure into a Max() but it does not accept nested aggregation
If there is a way around that it would be appreciated
at the top you can see an example representing rangesum, bottom you can check the simple data model.
Its now shows the max figure
please mark helpful the answer.
May be like this
FirstSortedValue(FieldName, -Aggr(YourExpressionHere, FieldName))
Here fieldname is the field which would would include A, B, or C and YourExpressionHere is the expression you used for your table
Can you express this better?
Use below expression
Please note that here I've given Alphabet and percentage field name of your data.
Hopefully, this will help you.
Retrieving data ...