Matrix Table - Subtotal VS Grand Total Issue!

[SLONG0718]

I have created a matrix table with 3 fields under row, 1 field under columns and then values.  I am trying to achieve the look of the tabular format from excel in this matrix.  I have removed the stepped layout and trying to just have the grand total at the bottom calculating for each of the columns BUT in order to have that I have to have the individual subtotals on.  I created a hierarchy group for the fields under my rows and it works if I only have 2 fields but as soon as I add a third field it adds the subtotals back in.  Is there any workaround?  I have been trying to figure this out and I am stuck.

I want to maintain each of the fields under rows in that tabular format or having their own individual colulmn while ONLY subtotaling the year columns.  Any help is greatly appreciated

matrix table with visible grand totals with my formatting selections to the righttable showing the fields for rows (including the created hierarchy containing 2 fields), columns and valuesAdded a 3rd field to the hierarchy and individual row totals are visable

[v-yiruan-msft · Accepted solution]

Hi @SLONG0718 ,

You can follow the steps below to get it:

1. Navigate to Format pane

2. Find the option "Row subtotals", toggle off the option "Show subtotal" for the row level "Basis of Financials"

Best Regards

[Greg_Deckler]

@SLONG0718 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

Also, MM3TR&R might be of particularly help here: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Fabric Community