The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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]
)
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
80 | |
78 | |
43 | |
37 |
User | Count |
---|---|
158 | |
111 | |
64 | |
59 | |
54 |