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

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

4 Replies

tamerj1

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

andrieskoo
Frequent Visitor
4 years ago
Thanks a lot!

amitchandak
Super User
4 years ago
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
  Frequent Visitor
  4 years ago
  Thax, for Your help, but it doesn't workr as I expect

Forum Discussion

Total sum calculate incorect