cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBITesting
Helper IV
Helper IV

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

PowerBITesting_0-1597338750859.png

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

2 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

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_0-1597343032720.png

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Turn off eveyr row except for the name.

 

PBIX file attach.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

8 REPLIES 8
MFelix
Super User
Super User

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_0-1597343032720.png

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

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

Hi @PowerBITesting ,

 

What do you cannot achieve?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

 

PowerBITesting_0-1597755963063.png

 

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".

 

MFelix_1-1597756805740.png

 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



@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  

 

PowerBITesting_0-1598884279688.png

 

Turn off eveyr row except for the name.

 

PBIX file attach.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

@MFelix  Worked thank you !!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!