PowerBI - Grand Total is Incorrect

[Mathusan1997]

Hi Everyone,

I am fairly new to PowerBI and came across an issue regarding the grand total not adding up correctly. Below is my formula.  

Forecasting = if ([PSCost] > 0.0 && AVERAGE('PS_Dashboard'[SOW Amount]) < ([LastMonthTotal]), (AVERAGE('PS_Dashboard'[SOW Amount])-[LastMonthTotal]-[PSCost]), IF([AvgPCProjectStatus] = 0.0 && [AvgPCSameMonth] = 1.0, AVERAGE('PS_Dashboard'[SOW Amount]) - [LastMonthTotal], PS_Dashboard_Measures[PSCost]))

As seen above, the total is displaying as 4,250.00 whereas it should be 50. I read several threads on this forum and tried the "HASONEFILTER" function but had no luck with that as well. Please also keep in mind that I am using two different page level filters. One for "Month" and another for "Name".

Any help is appreciated. 

Thank you! 

[dax]

Hi Mathusan1997,

According to your description, is [Forecasting] a measure? Or a calculated column? This might be caused by current context, I suggest you could try to share your sample data for me,  then I will  help you more correctly .

Or you also could refer to DAX Fridays! #25: Wrong Grand Totals in Power BI for detail.

Best Regards,

Zoe Zhi

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