Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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] )
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: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
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.