topic How to Calculate the Sum by filtering two other tables in DAX Commands and Tips

How to Calculate the Sum by filtering two other tables

Anonymous — Wed, 20 Mar 2024 23:50:19 GMT

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

Re: How to Calculate the Sum by filtering two other tables

Anonymous — Thu, 21 Mar 2024 06:54:55 GMT

Hi, Anonymous

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.

Re: How to Calculate the Sum by filtering two other tables

Anonymous — Fri, 22 Mar 2024 00:03:29 GMT

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)