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  = &&

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  = &&