Applying filter in UNION WITH DISTINCT to create new table

[wesentadesse99]

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!  

[lukiz84 · Accepted solution]

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

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