Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago

Need help with Measure

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 AU...
Need Help
Show and Tell
ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

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's avatar
    gauravnarchal
    Post Prodigy
    4 years ago

    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.