SUM ALL VALUES EXCEPT

[Tiago_Varela]

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

So, i want the sum of A, C, E, F

Is there any dax formula for this?

Thanks

[Anonymous · Accepted solution]

Hi @Tiago_Varela

Try this

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

Thanks
Raj

[ngct1112]

@Anonymous Do you have any idea why there is apostrophe'' for 'Table A' but nothing for Table B

which I could not refer to my Table B in your provided formula

[ngct1112]

@Anonymous Here is the similar model I am working on. I find that I could not put Table B in the formula

[Tiago_Varela]

Thanks Raj