Forum Discussion

Regular Visitor

1 year ago

Solved

The difference between scenarios containing different data

Hi, I really need help as I haven't found an answer despite searching the forums. I have production forecasts (MPS) for individual products (Product), each row represents one product that is schedul...

Anonymous

Not applicable

1 year ago

Hi maart21 ,

Please try the measure:

Measure = 
    Var _Previous=
        CALCULATE(
            SUM(Arkusz1[Qty]),
            FILTER(
                ALL(Arkusz1),
                [MPS]="B"&
                RIGHT(SELECTEDVALUE(Arkusz1[MPS]),2)-1&&
                [PLAN-FINISH].[Miesiąc]=SELECTEDVALUE(Arkusz1[PLAN-FINISH].[Miesiąc])&&
                [Produkt]=SELECTEDVALUE(Arkusz1[Produkt]
        )
    )
)
RETURN
SUM(Arkusz1[Qty])-_Previous

Best regards,

Lucy Chen

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

maart21

Regular Visitor

1 year ago

Thank you v-xinc-msft,
looks good, but when I add sums to my my matrix, values are not correct.

Anonymous
Not applicable
1 year ago
Hi maart21 ,

Please try this.

Result = Var _table=SUMMARIZE(Arkusz1,[MPS],Arkusz1[Produkt],Arkusz1[PLAN-FINISH].[Miesiąc],"Diff",[Measure]) RETURN SUMX(_table,[Diff])

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The difference between scenarios containing different data.pbix46 KB