Measure - check if not found in a column

[J_o_n_a_s]

Hi all,

I have:

• Table 1 with a master list of Project names.
• Table 2 with a column of project names (these names are manually entered).

There is a 1 to many relationship from Table 1 to Table 2

I want to find out if there are any project names in table 2 that are not found in table 1 (checking for mistakes basically). Could i do this with a measure? I would not like to add more columns to the tables. 

I tried using this (https://community.powerbi.com/t5/Desktop/check-if-value-contains-in-another-table-through-measure/m-...) but the relationship is the opposite so didn't work. 

Thanks everyone.

Jonas

[J_o_n_a_s]

Perfect. Thanks a lot. Power BI is easy when you know what you're doing 😀

Jonas

[amitchandak · Accepted solution]

@J_o_n_a_s , Create a visual with project name from Table 1 and Table 2 and filter this visual (using visual level filter) for table 1 project name is blank.

You will get the list

or a new table

except(Distinct(Table2[Project Name]), Distinct(Table1[Project Name]) )