Total of ABS difference is the same with total of difference

[Anonymous]

Hi All, 

I have the following two simple measures. 

DIF_M1 L3 = [Sum MFR1 L3]-[Sum Actuals L3]

and

ABS_M1 L3 = Abs( [Sum MFR1 L3] - [Sum Actuals L3] )

and I get the following results

Obviously the the absolute values are calculated in the fisrt column. However the Total of the first column (ABS_M1 L3) is not the sum of the values of the column but the absolute of the total of DIF_M1 L3.

My question is the following, 

How can I get the sum of ABS_M1 L3 as total at the end of the column?

[AlB]

Hi @Anonymous

Try

ABS_M1 L3 =
SUMX ( Table1, ABS ( [Sum MFR1 L3] - [Sum Actuals L3] ) )

You'd need to show the structure of your tables and the definitions of your measures to allow a more accurate solution