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
ahadkarimi's avatar
ahadkarimi
Icon for Solution Specialist rankSolution Specialist
2 years ago

Hi yamacha, try this SUMMARIZE, if you encounter any issues, let me know.

 

ERROR_LP_PLS = 
SUMX(
    SUMMARIZE(
        ACTUAL_LP,
        LP_ABBR[LP_ABBR],
        TIME[MonthDate],
        MASTER_PL[ProductLine5],
        "ActualQty", SUM(ACTUAL_LP[Actual Qty]),
        "ForecastQty", SUM(FCST_LP[FCST Qty])
    ),
    ABS([ActualQty] - [ForecastQty])
)

 

 

Did I answer your question?  If so, please mark my post as the solution!✔️
Your Kudos are much appreciated!  Proud to be a Responsive Resident!

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

Thanks ahadkarimi

I created two columns (end with Neo) with your codes as below. As only 'ACTUAL_LP' is summarized in your code so it will miss the lines w/o actual demand but still with forecast, and ultimately underestimate the error.