Multiple sub totals in a single table or matrix

[mibu]

Team,

Trying to learn a measure or way by which I can have a table or matrix in Power BI sub total as follows:

Right now, in a single table, I can get A, B, C, D, and grand total to show...  but not A+B or A+B+C.

Thanks in advance!

Best,

mibu

[mahoneypat · Accepted solution]

This could be done with calculation groups, adapting this approach (see the 2nd part) on asymmetric matrix.

Building a Matrix with Asymmetrical Columns and Rows in Power BI - Excelerator BI

Pat

[sm_talha · Accepted solution]

You need to create hierarchies by adding columns then use them in the matrix.

[mibu]

This did the trick.  Thank you!  🙂

[sm_talha]

You're Welcome 🙂

[mahoneypat · Accepted solution]

This could be done with calculation groups, adapting this approach (see the 2nd part) on asymmetric matrix.

Building a Matrix with Asymmetrical Columns and Rows in Power BI - Excelerator BI

Pat