Forum Discussion
Microsoft EmployeeMultiple sub totals in a single table or matrix
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
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
You need to create hierarchies by adding columns then use them in the matrix.
4 Replies
sm_talhaResolver II
You need to create hierarchies by adding columns then use them in the matrix.
- mahoneypat
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
