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
AU04
GROJ
MORJ
MRAJ
MRAJ-1
12786
MRAJ-2
87979
Need Help
Show and Tell

2 Replies

  • 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.