sumx wrong Sum

[Analitika]

PBI 

m_SSA_3 = 
VAR valText1 = "1"
VAR valText12 = "f"
VAR Result =
  CALCULATE (  CALCULATE (
        CALCULATE (
            SUM ( Table1[OPE_SUMOL] ),
            FILTER (
                Table1,
                Table1[OP_ATS] IN { 0 }
                    && NOT Table1[OP_VIE] = 3
                    && NOT Table1[ZU0_KOD] IN { valText1, valText12 }
            )
        ),
        FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
    )
        - CALCULATE (
            CALCULATE (
                SUM ( Table1[OPE_SUMOL] ),
                FILTER (
                    Table1,
                    Table1[OP_ATS] IN { 0 }
                        && Table1[OP_VIE] = 3
                        && NOT Table1[ZU0_KOD] IN { valText1, valText12 }
                )
            ),
            FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
        )
        - CALCULATE (
            CALCULATE (
                SUM ( Table1[OPE_SUMOL] ),
                FILTER (
                    Table1,
                    Table1[OP_ATS] IN { 2 }
                        && NOT Table1[ZU0_KOD] IN { valText1, valText12 }
                )
            ),
            FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
        )
        - CALCULATE (
            CALCULATE (
                SUM ( Table1[OPE_SUMOL] ),
                FILTER (
                    Table1,
                    Table1[OP_ATS] IN { 0 }
                        && Table1[ZU0_KOD] IN { valText1, valText12 }
                        && Table1[_MZA2] > 0
                )
            ),
            FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
        )
        - CALCULATE (
            CALCULATE (
                SUM ( Table1[OPE_SUMOL] ),
                FILTER (
                    Table1,
                    Table1[OP_ATS] IN { 0 }
                        && Table1[ZU0_KOD] IN { valText1, valText12 }
                        && Table1[_MZA2] < 0
                )
            ),
            FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
        ),
        FILTER(Table2,Table2[SK/AV]="IAT")
    )


RETURN

    IF (
        SELECTEDVALUE(  Table1[rus_kod] ) = "PREK_G" || SELECTEDVALUE(  Table1[rus_kod] ) = "NUOLAI", Result, -Result 
    )

Sumx sum wrong

m_SSA_3_Total = 
SUMX(
    values(Table1[_MN]),
    _Measures[m_SSA_3]
)

Why?

[amitchandak · Accepted solution]

@Analitika , Try like

m_SSA_3_Total =
SUMX(
summarize(Table1,Table1[_MN],Table1[RUS_KOD],"_1"
_Measures[m_SSA_3]), [_1]
)

or
m_SSA_3_Total =
SUMX(
summarize(Table1,Table1[_MN],Table1[RUS_KOD],Table1[did_date],"_1"
_Measures[m_SSA_3]), [_1]
)