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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
AnWe
New Member

"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
v-yifanw-msft
Community Support
Community Support

Thank you @DataNinja777  for your prompt reply.

Hi @AnWe ,
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 @AnWe 

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors