Forum Discussion

Tiago_Varela's avatar
Tiago_Varela
Icon for Helper I rankHelper I
8 years ago
Solved

SUM ALL VALUES EXCEPT

Hi all, I have a problem, i'm triyng to sum all the values in a table, except the ones in another table. Example:   Table 1 A = 10 B = 10 C = 30 D = 30 E = 50 f = 60   Table 2 B D   S...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Tiago_Varela

     

    Try this

    Sum_Value = CALCULATE(SUM('Table_A'[Value]),
                       FILTER('Table_A','Table_A'[ID]<>RELATED(Table_B[ID])))

     

     

     

    Thanks
    Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Tiago_Varela

 

Try this

Sum_Value = CALCULATE(SUM('Table_A'[Value]),
                       FILTER('Table_A','Table_A'[ID]<>RELATED(Table_B[ID])))

 

 

 

Thanks
Raj

Tiago_Varela's avatar
Tiago_Varela
Icon for Helper I rankHelper I
8 years ago

Thanks Raj