Forum Discussion
mibu
Microsoft Employee
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 no...
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.
