Forum Discussion
Solved
Incorrect Total
I'm running into a problem with incorrect totals in my measure despite using a SUMMARIZE formula which based on articles online should fix the issue. "Forecast Sum" = Forecast on the product fami...
Simplify it. Get rid of the SUMMARIZE code
Simplify it. Get rid of the SUMMARIZE code
HotChilli it worked! many thanks for help!
Correct formula:
Forecast Split by Item = SUMX(VALUES(dim_product[Item No]),Forecast[Forecast Sum]*Bookings[Item Allocation])
