Forum Discussion

melimob1's avatar
melimob1
Helper I
1 year 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
    1 year ago

    OR = ||

    AND  = &&

melimob1's avatar
melimob1
Helper I
1 year 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
    Super User
    1 year ago

    Hi melimob1 ,

     

    That's right, || means OR. 

     

    Best regards,

    • melimob1's avatar
      melimob1
      Helper I
      1 year 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
        Super User
        1 year ago

        OR = ||

        AND  = &&