Forum Discussion

PshemekFLK's avatar
PshemekFLK
Icon for Helper IV rankHelper IV
4 years ago
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...
Need Help
Need Help DAX measure
  • HotChilli's avatar
    HotChilli
    4 years ago

    Simplify it.  Get rid of the SUMMARIZE code

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

Try changing

Forecast Split by Item to be a SUMX over the Product Family (you'll need a VALUES function in there)
  • PshemekFLK's avatar
    PshemekFLK
    Icon for Helper IV rankHelper IV
    4 years ago

    HotChilli, that's what I tried to do with "Forecast Split by Item_Summarize" measure but it didn't fix the issue