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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
NewBee_M
Regular Visitor

Use measures in a matrix to display the total column as a grand total and sum if totals.

Hello,

I recently started using Power BI and have two questions regarding measures in a matrix to display the total column as a grand total and sumif totals. Please bear with me if these questions have already been answered; I was not able to find a solution after searching for it.

I have two tables: one is the basic info and the second is the detailed info. Please see below for Table 1 and Table 2, as well as the expected results. I am having difficulties in the highlighted section.

NewBee_M_0-1742583364874.png

NewBee_M_1-1742583392544.pngNewBee_M_2-1742583408341.png

When I turn on column subtotals, it shows the grand total but also includes subtotals for each category, which I cannot remove. I then tried to use a measure to create a sum and group by, but it still doesn’t work. Any help would be greatly appreciated.

Question 1: The grand total is simply the sum of each row, how to get the grand total for each row?

Question 2: How to get the subtotal with Sum if the category is Z1 for each row?

Thank you!

1 ACCEPTED SOLUTION

thats is correct. Using table, you cant get the same layout but you can get subtotal Z1. Using Matrix, you cant get the independant subtotal for Z1

View solution in original post

7 REPLIES 7
NewBee_M
Regular Visitor

Thank you very much for your swift response! It perfectly addresses my 1st question. Your assistance is greatly appreciated!

For question 2, i dont think you can do it in matrix, its just the way the matrix works.

You might be able to get it using Table instead, and create specific measures for every column you need.

If I use a table instead of Metrix, I won’t get the same layout as illustrated above, right?

thats is correct. Using table, you cant get the same layout but you can get subtotal Z1. Using Matrix, you cant get the independant subtotal for Z1

Many thanks Tutu_in_YYC!

Have fun with PBi!

Tutu_in_YYC
Super User
Super User

Have you tried changing the setting on the column level? ie turn off subtotal for a certain column

Tutu_in_YYC_0-1742584392571.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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