Forum Discussion

mhsk's avatar
mhsk
Icon for Helper II rankHelper II
3 years ago
Solved

Total of Measure doesnt work

Hi,   I have a measure that calculates Projected Qty on Hand in warehouse based on Qty and Demand, calculation is all good on item level but i can not crack it how to approach to make a summary of ...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi mhsk ,

     

    Add the following measure to your model:

    Projection Total = 
IF (
    ISINSCOPE ( Extract_ld_det_Items[ld_part] ),
    [Projection QOH],
    SUMX (
        SUMMARIZE (
            ALLSELECTED (
                Extract_ld_det_Items[ld_part],
                Extract_ld_det_Items[Extract_mrp_det (2).Start of Week]
            ),
            Extract_ld_det_Items[ld_part],
            "ProjectionValue", [Projection QOH]
        ),
        [ProjectionValue]
    )
)

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi mhsk ,

 

Add the following measure to your model:

Projection Total = 
IF (
    ISINSCOPE ( Extract_ld_det_Items[ld_part] ),
    [Projection QOH],
    SUMX (
        SUMMARIZE (
            ALLSELECTED (
                Extract_ld_det_Items[ld_part],
                Extract_ld_det_Items[Extract_mrp_det (2).Start of Week]
            ),
            Extract_ld_det_Items[ld_part],
            "ProjectionValue", [Projection QOH]
        ),
        [ProjectionValue]
    )
)

 

 

  • mhsk's avatar
    mhsk
    Icon for Helper II rankHelper II
    3 years ago

    mfed yes, this code solves my issue totally! Great job!

     

    Unfortunatelly i can see i have another issue, my calculation is not as expected on previous step, what i was trying to to is to QOH (QOH_NOW) - Running Total of Demand (SUP-DEM_3) , to calculate Projection each next week.
    and again as it works on SUP-DEM_3 level but not if i wrap it up into next measure  Projected QOH

     

    have an idea?

    • mhsk's avatar
      mhsk
      Icon for Helper II rankHelper II
      3 years ago

      So to add a comment, i end up with having a correct date on which i need a measure value but can not get this measure value (so the previous value - Projection QOH)