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

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

Forum Discussion

Total of Measure doesnt work

Related content

% of total measure

Total of Measure

Measure Total Incorrect

Measure Total, again

Adjust this measure to show totals