How to Calculate the Sum by filtering two other tables

[SLeepyhead]

I try to sum a value from table a exculding values where table  column y does not equall 1 and table c  coulmn c not in {"260","261","262","263"}

im using the below measures 

CALCULATE(

    SUM(x),

    FILTER(table a ,RELATED(Table b [y]) <> "1"

   &&  Not RELATED(table c [c ]) in {"260","261","262","263"}))

what is currently happening its exculding at Table b [y])  that equel 1 regardless of table c [c ] and excluding all table c [c ] that equal {"260","261","262","263"} 

it not applying the "and" part of the measures 

[SLeepyhead]

example of tables  

Table a
Date	A	Region	Site	table b key	table  c
1/01/2014	1	a	2	1	1
2/01/2014	2	b	3	2	2
3/01/2014	1	a	4	3	3

Table b
key	b
1	2
2	2
3	1

table C
key	c
1	260
2	400
3	260

the result im exspecting is 3 sum (table a ,A)

[Anonymous]

Hi, @SLeepyhead 

Here are my thoughts, maybe you can try the following DAX:

CALCULATE(
    SUM(table a[x]),
    FILTER(
        ALL(table a),
        RELATED(Table b[y]) <> "1"
    ),
    FILTER(
        ALL(table c),
        NOT RELATED(table c[c]) IN {"260", "261", "262", "263"}
    )
)

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.