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
Have you tried the max function ?
=num(max( Value),'0.0%')
Daniel
Hi Michael,
Try this:
Max(Fieldname)
Thanks,
Arvind Patil
Hello
Forgot to say that the values are in created in different measures
They are not in the dataset
then RangeMax() function?
=RangeMax(sum(Value1),sum(Value2))
if no could you share the example?
Hello
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
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
at the top you can see an example representing rangesum, bottom you can check the simple data model.
That worked
Its now shows the max figure
Thank you
please mark helpful the answer.
Thanks.
Daniel