Forum Discussion

yamacha's avatar
yamacha
Icon for Helper I rankHelper I
2 years ago

Matrix calculation with multi-layered SUMX

Hi there I have been struggling with the  Matrix Calculation for years, and SUMX + VALUES seems to be most handy way that can cover most situations. However as you can  below it won't help when ther...
Need Help
yamacha's avatar
yamacha
Icon for Helper I rankHelper I
2 years ago

Hi Xingshen

Thanks for the warm follow-up. I tried with your codes, and found the issue below

As you were using the naming 'Table' to represent multiple tables, I'm kinda confused on the syntax below. I assume the 3 Tables with column quoted refer to the master tables, then what is the first 'Table'?  I do have 2 tables for actual and forecasted demand respectively. Thanks.

 ALLEXCEPT('Table', 'Table'[LP_ABBR], 'Table'[MonthDate], 'Table'[ProductLine5])

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi yamacha ,

Has your problem been solved after all this time, or has a new problem arisen, if there are any other questions on this issue, feel free to contact me and I'll get back to you as soon as I receive the message.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

  • yamacha's avatar
    yamacha
    Icon for Helper I rankHelper I
    1 year ago

    Hi Xingshen

    Sorry for the late response, busy indeed these days.

    I kinda locate the root cause (not the aggregation forumula issue): once I apply the 'RemoveEmpty' function that is simply to scope out lines with empty Actual Qty/FCST Qty, the total will become weird (2nd pic below). Just wonder if you have any clue on it? Thanks!