Applying filter in UNION WITH DISTINCT to create new table

wesentadesse99 — Mon, 10 Oct 2022 08:28:49 GMT

Hi All,

I want to creat a uniqe value from different table Table 1, Table 2, Table 3 and applyed the following formula

New Table = UNION(DISTINCT('Table 1'[Name]), DISTINCT('Table 2'[Name]),DISTINCT('Table 3'[Name])) and it works for me.

But I want to filter out Values/Attribute with in Table 2 so that this values shoud be excluded from the new table.

Would you please support on this?

Thank you!

Re: Applying filter in UNION WITH DISTINCT to create new table

lukiz84 — Mon, 10 Oct 2022 08:57:37 GMT

Replace DISTINCT('Table 2'[Name]) with

CALCULATETABLE(DISTINCT('Table 2'[Name]), 'Table 2'[Name] <> xyz)