Rows total is not matching with grand total

[Anonymous]

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 (
            BudgetCSV,
            BudgetCSV[Entity/Facility],
            BudgetCSV[Month],
            BudgetCSV[Category],
            "Days", SUM ( BudgetCSV[CLM013] )
        ),
        [Days]
    )
VAR CLM012_CLM011 =
    SUMX (
        SUMMARIZE (
            BudgetCSV,
            BudgetCSV[Entity/Facility],
            BudgetCSV[Month],
            BudgetCSV[Care Level],
            "RUG", SUM ( BudgetCSV[Rate_distribition input] )
        ),
        [RUG]
    )
VAR CLM010 =
    CALCULATE ( AVERAGEX ( 'BudgetCSV', 'BudgetCSV'[CLM010] ) )
VAR nonblankCLM010 =
    IF ( ISBLANK ( CLM010 ), 1, CLM010 )
RETURN
    SUMX (
        SUMMARIZE (
            BudgetCSV,
            "new", ( [BudgetRevenue_new] * nonblankCLM010 ) * CLM013
        ),
        [new]
    )

[v-lili6-msft]

hi, @Anonymous

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

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

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,

Lin