Flag to see if a column value exists in a filtered table

[byr10112]

I'm trying to create a flag column in one of my tables to see if the employee speaks French or not. I have two tables. One is the list of employees and the other one is the languages these employees speak and their proficiency levels. Two tables are linked to each other via employee number. Below is a basic structure of the tables:

Employee Table:

Employee Name

John Adam

David Ricardo

James Smith

Michael Scott

Language Table:

Employee Name	Language	Proficiency Level
John Adam	French	Expert
John Adam	English	Expert
John Adam	Spanish	Intermediate
John Adam	Hindu	Introductory
Michael Scott	English	Expert
Michael Scott	French	None
David Ricardo	French	Experienced
David Ricardo	Portuguese	Expert

I want the first table to have a column called French Flag. Here is what I hope it looks like:

Employee Name	French Flag
John Adam	1
David Ricardo	1
James Smith	0
Michael Scott	0

Below is what I tried, but I'm getting a Number of arguments in invalid. Function CONTAINSROW must have a value for each column in the table expression" error, and I'm not sure what it means:

French Speaking =

var _a = FILTER('Language Table', AND(

'Language Table'[Language] = "French",

(

'Language Table'[Proficiency Level] = "Expert" ||

'Language Table'[Proficiency Level] = "Experienced" ||

'Language Table'[Proficiency Level] = "Intermediate")

))

Return

IF(Employee Table[Employee Name] IN _a,1,0)

How can I make this work?

[selpaqm · Accepted solution]

@byr10112 you may use as below.

French Flag = IF('Language'[Language]="French" &&
                ('Language'[Proficiency Level]="Expert" || 
                 'Language'[Proficiency Level]= "Experienced" || 
                 'Language'[Proficiency Level]="Intermediate"),1,0)

Employee.pbix