Wrong totals

[Analitika]

I have main measure which produce wrong total if m_SSA_3 measure is changed

m_SSA = 
VAR Sum1 = [m_SSA_1] - [m_SSA_2]
VAR Sum2 = [m_SSA_3] - [m_SSA_4]

RETURN
    SWITCH(TRUE(),
        "IAT" in distinct ( Table2[SK/AV] ) ,
            Sum2,
        "GIA" in distinct ( Table2[SK/AV]),
            Sum1
    )
 

if m_SSA_3 measure is changed from this

m_SSA_3 = 
VAR valText1 = "$PRD"
VAR valText12 = "$PR.L"
VAR Result =CALCULATE ( .... huge countings)

RETURN
    SWITCH(TRUE(),
        "IAT" in distinct ( Table2[SK/AV] ) ,
            -Result,
        "GIA" in distinct ( Table2[SK/AV]),
            Result
    )

Good total

to this

m_SSA_3 = 
VAR valText1 = "$PRD"
VAR valText12 = "$PR.L"
VAR Result =CALCULATE ( .... huge countings)
VAR discount =
    IF (
       "PR" IN DISTINCT ( Table1[rus_kod] )|| "NU" IN DISTINCT ( Table1[rus_kod] ), Result, -Result 
     )

RETURN
    SWITCH(TRUE(),
        "IAT" in distinct ( Table2[SK/AV] ) ,
            discount,
        "GIA" in distinct ( Table2[SK/AV]),
            Result
    )

Wrong total, must be -3982.03

[amitchandak · Accepted solution]

@Analitika , this happens when you use switch or if.  refer filter . Of have formula like

new m_SSA_3 = sumx(values(Table[_MN]),[m_SSA_3])

Or move switch  calculation inside sumx or countx