Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Rows total is not matching with grand total

HI ,

Issue is Highlighted Total of the column Budget Revenue Calculation is wrong . It should be sum of the rows of that column i.e – 21247


Budget Revenue Calculation =
VAR CLM013 =
    SUMX (
        SUMMARIZE (
            "Days"SUM ( BudgetCSV[CLM013] )
VAR CLM012_CLM011 =
    SUMX (
        SUMMARIZE (
            BudgetCSV[Care Level],
            "RUG"SUM ( BudgetCSV[Rate_distribition input] )
VAR CLM010 =
    CALCULATE ( AVERAGEX ( 'BudgetCSV', 'BudgetCSV'[CLM010] ) )
VAR nonblankCLM010 =
    IF ( ISBLANK ( CLM010 )1CLM010 )
    SUMX (
        SUMMARIZE (
            "new", ( [BudgetRevenue_new] * nonblankCLM010 ) * CLM013


Community Support
Community Support

hi, @Anonymous

This looks like a measure totals problem. Very common. See this post about it here:

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:


IF not your case ,Please share your pbix for us. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading


Best Regards,


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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors