Create table with intersection column

[cyed]

Hi!

I have a table with two columns: one of users ("User") and one of applications ("Application") they use.
I have a second table with one column: the applications that can be used ("White List").
I need to create a third table with one column: consisting of applications that cannot be used ("Blacklist"), to use it as a filter in the first table.

Can anybody help me?

Thanks in advance!

[v-eachen-msft · Accepted solution]

Hi @cyed ,

You could refer to the following DAX to create a new table:

New Table = 
VAR a = DISTINCT('Table'[Application])
var b = DISTINCT('Table (2)'[White List])
return
EXCEPT(a,b)