Get highest value of a column with pre-calculated values from expression

[BernardBernoulli]

Hi,

I have a data table with percentages which are calculated results of an expressions, which measures the difference between two values.

e.g.

Column 1
-2,70%
-1,00%
5,00%

Now I wanted to write another expression which reads these results in the column and checks which of them is the highest and use it to display it in a visual KPI window.

I've tried the following expression:

rangemax(sum(total [Column 1]))

Unfortunately this doesn't seem to work and results in a "0".

Is there any other way to do this?
Thanks in advance!

[Or]

You would need to use some sort of aggr() here to tell the expression what you're aggregating by. Since you didn't specify in your post, I can't specify any further than that.

[BernardBernoulli]

Basically I want to achieve that in the given example the result is 5,00% as this is the highest value of the column.

But it seems that max() and FirstSortedValue() can't be used here because the values of column only exists based on another expression.
(Sorry, english is not my native language it's hard to explain)