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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Anonymous
Not applicable

"Row SubTotal" => Total row shows up blanks

 

Hi all,

 

I need some help as I'm facing a problem even after turn on "Row SubTotal" , the Total row does not show up any summation of the above line items.

 

It just shows a blank.    Can anyone help?

 

AnWe_0-1716649873954.png

 

 

2 REPLIES 2
Anonymous
Not applicable

Thank you @DataNinja777  for your prompt reply.

Hi @Anonymous ,
If the total rows are shown as blank, it may be due to the way the measures are calculated or a specific configuration. You can follow the steps below to troubleshoot and resolve the issue:

1.Ensure that the measures used for row subtotals are properly defined and designed to aggregate values as expected.

2.Relationships between tables or the way data is structured may affect how row subtotals are calculated. Please review the relationships and ensure that they are set up correctly to support aggregation.

 

If you are still having problems, please provide the measures you are using.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DataNinja777
Super User
Super User

Hi @Anonymous 

In order to assess the reason for the subtotal not showing up, please could you share the dax measure you are using in your table visualization?  

Best regards,

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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