Wrong Matrix Total values

[Anonymous]

The matrix table is giving wrong calculations for the sub-category. I'm trying to get the remaining budget, but it's giving me the total remaining budget values instead. Can anyone help me?

Variance = var test =  SUMX('calculate',[Planned Budget]) - SUMX('calculate','calculate'[Actual Budget])return IF(ISBLANK(test),0,test)

[ribisht17]

What about using SUM only, not SUMX ?

Regards,

Ritesh