Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mibu
Employee
Employee

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
Employee
Employee

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

 

 

 

 

This did the trick.  Thank you!  🙂

You're Welcome 🙂

mahoneypat
Employee
Employee

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


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.