Total sum calculate incorect

[andrieskoo]

Hi everyone,
Please help me to find solution how to fix my measure.
I have a table and in earch row is calculating measure named "Income", in row in calculate corektly, byt in sum and in cart it calculate incorect. I khow that because of context, but how to write a correct folmula?
My measure is 

Income = 
VAR rozr = 
 IF(
        SUM('Registr VAT'[SUM])=0 && SUM(RW[SUM])=0,
        BLANK(),
        (
        SUM(FS[SUM])- SUM('Registr VAT'[SUM])-SUM(RW[SUM])
        )
 )

RETURN rozr

Link to .pbix https://we.tl/t-bPXOmpkpnu 

[tamerj1 · Accepted solution]

Hi @andrieskoo 
Please refer to the sample file with the solution https://we.tl/t-S1IzTm6gBN

Income = 
SUMX (
    SUMMARIZE ( Contracts, Contracts[ID], Contracts[SIGN_DATE], Contracts[STATUS] ),
    VAR VATSUM = CALCULATE ( SUM ( 'Registr VAT'[SUM] ) )
    VAR RWSUM = CALCULATE ( SUM ( RW[SUM] ) )
    VAR FSSUM = CALCULATE ( SUM ( FS[SUM] ) )
    RETURN
        IF ( 
            VATSUM <> 0 || RWSUM <> 0,
            FSSUM - VATSUM - RWSUM
        )
)

[andrieskoo]

Thanks a lot!

[amitchandak]

@andrieskoo , Try like

Income =
VAR rozr =
Sumx(values(Table[ID]),
IF(
SUM('Registr VAT'[SUM])=0 && SUM(RW[SUM])=0,
BLANK(),
(
SUM(FS[SUM])- SUM('Registr VAT'[SUM])-SUM(RW[SUM])
)
)
)
RETURN rozr

[andrieskoo]

Thax, for Your help, but it doesn't workr as I expect