Matrix - Total on all records ,not in sub group records ?

[PowerBITesting]

When I made "Row Subtotals" On that show each group sub toatal , but I need only final sum with correct total?

[MFelix · Accepted solution]

Hi @PowerBITesting ,

On the subtotals select the option per row level and then turn off all of them except the first column (on my case is the Cat2):

[MFelix · Accepted solution]

Hi @PowerBITesting ,

On the subtotals select the option per row level and then turn off all of them except the first column (on my case is the Cat2):

[PowerBITesting]

Recently I have updated my Power BI desktop and colud not achive the same?Any idea?

[MFelix]

Hi @PowerBITesting ,

What do you cannot achieve?

[PowerBITesting]

 I have updated the Power BI desktop and I cant see the options to hide Row leble total .  I need only total on bottom .

[MFelix]

Hi @PowerBITesting ,

On the matrix you are using you have more than one field in the row correct?

This option is the last one within subtotals,  if you do not find it try to use the search to find "Per row level".

What is the version of PBI you are using?

One additional question is the file you are using recent or was it created a few years ago? What can be happening if the file was created a long time ago is that the Matrix visualization is still the old one so you are not getting the new features like subtotals, check if when you select the matrix the icon of the matrix on the visualizations get's highligted or not, if not just click on it to "update" the visualization.

[PowerBITesting]

@MFelix  HI  I am attached PBIX file.  Please help. 

Version: 2.84.981.0 64-bit (August, 2020)

Power BI sub total Total issue.pbix  

[MFelix · Accepted solution]

Turn off eveyr row except for the name.

PBIX file attach.

[PowerBITesting]

@MFelix  Worked thank you !!