In PBI Matric, not quite getting the column total correct

[Arjunssekhar]

Hello there,

I'm trying to get the column total on each cluster correctly but not able to find a suitable solution to get the total of the column 'Abs. Forecast error' since the formula is taking the absolute value of the 'Forecast Error' and not adding the absolute values.

I have provided the screenshot of the table I'm using along with the formula for each use cases. Can you please let me know how to calculate the values inside the table and then to take the 'Absolute Forecast error' out of it?

[DataInsights · Accepted solution]

@Arjunssekhar,

Try a measure like this. The field in your matrix rows goes in the VALUES function.

Abs. Forecast error =
ABS ( SUMX ( VALUES ( DimensionTable[ColumnName] ), [Forecast Error] ) )