Grouping by ID to see if a certain value exists in column

[byr10112]

I have the following table: 

Request ID	Language Requested
1001	English
1001	French
1002	English
1003	French
1003	Spanish
1004	English

I'm trying to create a table view on PowerBI, where I would like to see if the customer requested (request ID) a French language service or not. I tried creating a column that said if the language requested is French then True else False, but I'm getting duplicate results that look like this:

ID	French Flag
1001	False
1001	True

Is there a way for me to group by the ID and check if the French language is requested in the request? Ideally the final table will look like:

ID	French Flag
1001	True
1002	False
1003	True
1004	False

Thanks

[DataInsights · Accepted solution]

@byr10112,

Try this measure:

French Flag = CALCULATE ( COUNT ( Table1[Request ID] ), Table1[Language Requested] = "French" ) > 0