Calculated Column in DAX to check if values appear in another column, create an array from a table

[walker4545]

Hello Power BI gurus, 

I need help with the following problem. I need to create a calculated column that evaluates whether a value appears in another column. 

Flag

Flag Colours

Red

White

Blue

Primary

Primary Colours

Red

Yellow

Blue

Primary Colour =

    VAR PrimaryArray = {"Red", "Blue", "Yellow"}

    VAR CheckPrimary = IF('Flag'[Flag Colours] IN PrimaryArray, "Primary Colour", "Not Primary Colour")

    RETURN CheckPrimary

The above code is a solution of how I would like the code to work (to calculate a column based on whether a value appears in an array). In the code above I'd like to replace the code in italics to bring in values from the column of another table. However, when attempting to declare the variable PrimaryArray against a column in the Primary Table I cannot access those values. 

How can I bring in the values from 'Primary'[Primary Colours] into an array that can be evaluated against to match values?

Thanks in advance!

[amitchandak · Accepted solution]

@walker4545 , Try like

Primary Colour =
VAR PrimaryArray = values(Primary[Primary Colours])
VAR CheckPrimary = IF('Flag'[Flag Colours] IN PrimaryArray, "Primary Colour", "Not Primary Colour")
RETURN CheckPrimary