Forum Discussion

maart21's avatar
maart21
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's avatar
    Anonymous
    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.

  • Anonymous's avatar
    Anonymous
    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.

maart21's avatar
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's avatar
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.