cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mibu
Microsoft
Microsoft

Multiple 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

21090901 Capture.PNG

2 ACCEPTED SOLUTIONS
mahoneypat
Super User
Super User

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

sm_talha
Resolver II
Resolver II

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

 

sm_talha_0-1631240557653.png

 

sm_talha_1-1631240607129.png

 

 

 

 

View solution in original post

4 REPLIES 4
sm_talha
Resolver II
Resolver II

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

 

sm_talha_0-1631240557653.png

 

sm_talha_1-1631240607129.png

 

 

 

 

View solution in original post

This did the trick.  Thank you!  🙂

You're Welcome 🙂

mahoneypat
Super User
Super User

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.