How to apply a formula to a measure

[coreySky]

I have the following table

And I have a measure on this table:

measure_a = average(Table[flow_mean])

I'd like to normalize the value of this measure using the following formula and create a new measure or column:

normalized = (x-min(x))/(max(x) - min(x)) * 100

Min(x) and Max(x) are the minimum and maximum averages in the `measure_a`.

I'm not sure how to perform this operation, but I'd appreciate any help.

[lbendlin · Accepted solution]

Read about SUMMARIZE, SUMMARIZECOLUMNS and AVERAGEX