Forum Discussion

NewBe1's avatar
NewBe1
Frequent Visitor
2 years ago
Solved

Getting incorrect Total when using measures in table -URGENT

Hello Power BI Community,

I hope you're all doing well. I'm currently working on a finance data project in Power BI, and I'm facing an issue with a DAX measure that calculates the total budget based on categories. The strange thing is that the values for each category seem to be correct, but when I calculate the overall total budget, it's incorrect.

Here's the DAX measure I'm using for the total budget:

(Budget FY24 = CALCULATE( SUM('Budget_Maint'[Budget]) , 'Budget_Maint'[Year]=MAX('Date Table'[Year]),'Budget_Maint'[NAME]=MAX(Mainaccount[Category]),'Budget_Maint'[State]=MAX(GENERALENTRY[STATE]),'Budget_Maint'[Period]=MAX('Date Table'[Period]))+0)

I have a table named 'Budget' with columns 'Category' and 'BudgetAmount.' Each category appears to have the correct budget amount, but when I sum them up, I get an inaccurate total.
I've double-checked my data, and everything seems fine at the category level. However, there might be something wrong with the way I'm calculating the overall total budget. Is there something I'm missing in my DAX formula?

If anyone has encountered a similar issue or has any insights into what might be causing this discrepancy, I would greatly appreciate your help and guidance. Any suggestions or alternative approaches to calculate the total budget would be invaluable.

Thank you in advance for your assistance!

 

 

Need Help

3 Replies