Forum Discussion

andrieskoo's avatar
andrieskoo
Frequent Visitor
4 years ago
Solved

Total sum calculate incorect

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 ca...
  • tamerj1's avatar
    tamerj1
    4 years ago

    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
        )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

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
        )
)