Calculating diviation between Column and Measure

[Olia]

Hello,

I'd like to ask a fairly dumb question, sorry.

I have a column with Amount, and I have a measure Rolling Average.

How can I calculate the difference between the two? I want to show the items who have the largest diviation for this month compared to the rolling average (the weird outliers basically).

should it be a column or a measure? can you just do 1 minus the other?

edit: edited the title to be more clear

[Stachu · Accepted solution]

you can subtract two measures or an aggregation of column e.g. SUM & a measure

I would create a new measure which would be SUM of the Amount column, and subtract that from the Rolling average measure

[Olia]

Thank you @Stachu for your quick reply and for your solution.