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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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



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



@MFelix  Worked thank you !!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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