Summing Power Pivot Measure

[erdist]

I added a simple measure to my pivot table to get the absolute value of variances (to calculate deviation).
To my surprise, the grand total of the measure calculates the absolute value of the original variance total and does not sum up the absolute values calculated in the rows.

Please advise how to sum up the absolute values of rows in the Total.
Many thanks!

 

[JB2020]

This measure will only return the absolute value of the total, rather than working out the absolute value of each and summing those. Depending how your data are formatted, you could try something like =SUMX(Table,ABS([Sum of Variance Value]))