Forum Discussion

melimob1's avatar
melimob1
Icon for Helper I rankHelper I
2 years ago
Solved

MEASURE - CONTAINSTRING - MULTIPLE TEXT

Hi, I have the below measure but it's not returning the correct results. (dummy text as example) I want to search column and count every time 'apples' or 'oranges' appear.   Total Client Count F...
  • gmsamborn's avatar
    gmsamborn
    2 years ago

    OR = ||

    AND  = &&

melimob1's avatar
melimob1
Icon for Helper I rankHelper I
2 years ago

actually, think I have just got it to work but would appreciate advice.. I added

|| after the first containstring... does this stand for 'or'?

 

many thanks

  • DataNinja777's avatar
    DataNinja777
    Icon for Super User rankSuper User
    2 years ago

    Hi melimob1 ,

     

    That's right, || means OR. 

     

    Best regards,

    • melimob1's avatar
      melimob1
      Icon for Helper I rankHelper I
      2 years ago

      thank you so much!! am new to PBI and haven't come across this yet!! very good to know!

      may I ask, what is the code for 'AND'?  is it + or & or and or something completley different?

      • gmsamborn's avatar
        gmsamborn
        Icon for Super User rankSuper User
        2 years ago

        OR = ||

        AND  = &&