The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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!
Solved! Go to 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
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!
Have you tried changing the setting on the column level? ie turn off subtotal for a certain column