Hi everyone, I am using the following formula, and I would like to calculate the ABS ERROR between the actuals and the forecast.However, as you can see the it is not calculating at the pivot level. Shouldn't SUMX calculate the result at the aggregation provided in the Matrix? Why is not working? Thanks a lot, Riccardo

I created a varation of yours and it works. ABSERR CNS = SUMX(SUMMARIZE('Dataset Agg','Dataset Agg'[SHIP_FROM],'Dataset Agg'[SUB_DIV],'Dataset Agg'[Period]),[ABS CNS])