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

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