Forum Discussion
Incorrect Grand Total in Forecast Measure
I give up! First off, thank you in advance for the help. I have been struggling with this problem for a couple of days now and know it's a context issue. However, I am new to Power BI and haven't had...
dirty2k9 , try to change return like
Sumx(Values(Date[Fiscal Month]), result)
or
create a new measure
Projected Payroll 1=
Sumx(Values(Date[Fiscal Month]), [Projected Payroll])
Thank you for the quick response. I tried both of your suggestions and both produce incorrect values. See the attached pic.
