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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

Grand total in tablix in power bipaginated report

I am currently working on a Power BI paginated report, and I need to display only the rows where the "State" column is blank. However, in the grand total section, I would like to show the total including all values, regardless of the filters applied.

For instance, let's consider the following example:

ID State Amount

1 10
2 10

In this scenario, I would like to display only the first two rows where the "State" column is blank in my tablix.  In the sub-total, I would like to show the sum of the amounts for these blank rows (which is 20). In the grand total, I want to show the sum of amounts for all the rows (which is 80), including those with non-blank values in the "State" column.






I am seeking guidance on how to achieve this requirement in my Power BI paginated report. Thank you for your assistance.


Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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