The difference between scenarios containing different data

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.

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.