Matrix Balance Sheet Subtotal

[Sowmiya]

Hi Community,
I need a DAX to sum Subtotal for  Balance Sheet Matrix as shown in the figure. As exactly the same result show in the image I need

Thanks In Advance,

Sowmiya

[edhans · Accepted solution]

Just use the SUM() function. It will automatically adjust its totals by "row" in the matrix based on how you add data (main group, sub group, etc) to the matrix.