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

Simplify it.  Get rid of the SUMMARIZE code

  • PshemekFLK's avatar
    PshemekFLK
    Icon for Helper IV rankHelper IV
    4 years ago

    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])