Need help with Measure

[gauravnarchal]

Dear All - I need your help to create a measure as below

If Code is = “AAEA” or “CAPJ” or “MRAJ-1” or “12786” then return PASS else FAIL

DATA

CODE

AAEA

CALJ

CAPJ

AU31

AU04

GROJ

MORJ

MRAJ

MRAJ-1

12786

MRAJ-2

87979

[ryan_mayu]

@gauravnarchal 

Pls try this

Column = if('Table'[CODE] in {"AAEA","CAPJ","MRAJ-1" , "12786" },"PASS","FAIL")

Measure = if(max('Table'[CODE]) in {"AAEA","CAPJ","MRAJ-1" , "12786" },"PASS","FAIL")

[gauravnarchal]

Hi @ryan_mayu  - With the measure you suggested, it is taking a lot of time to load.  Also, I am getting the below error. 

I did not try the column as I am keener to achieve this through the measure.