Forum Discussion

Gazsim44's avatar
Gazsim44
Icon for Helper III rankHelper III
6 years ago
Solved

IF & CONTAINS with Multiple Values

Hi All,    I am trying to write a measure which is required to lookup text values in a column and then complete a simple division if the results are true. This proved easy enough when only one valu...
Need Help
  • judspud's avatar
    judspud
    6 years ago

    Hi Gazsim44 

     

    You could use the OR function.

     

    Measure = IF(OR(CONTAINS('Data','Data'[Category],"GP"),CONTAINS('Data','Data'[Category],"Other Value")), DIVIDE([Current Year Actual],[Current Year Budget]))

     

    Hope this helps

     

    Thanks,

    George 

judspud's avatar
judspud
Icon for Solution Supplier rankSolution Supplier
6 years ago

Hi Gazsim44 

 

You could use the OR function.

 

Measure = IF(OR(CONTAINS('Data','Data'[Category],"GP"),CONTAINS('Data','Data'[Category],"Other Value")), DIVIDE([Current Year Actual],[Current Year Budget]))

 

Hope this helps

 

Thanks,

George 

  • Gazsim44's avatar
    Gazsim44
    Icon for Helper III rankHelper III
    6 years ago

    Thanks George!

     

    Sounds obvious now you mention it - just didnt think! 🙂