MEASURE - CONTAINSTRING - MULTIPLE TEXT

[melimob1]

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 FRUIT  = 
CALCULATE(
    COUNT(_3_DataSet[Client]),
    CONTAINSSTRING(_3_DataSet[field], "APPLES" ),
        CONTAINSSTRING (_3_DataSet[field], "ORANGE" )
    )

 data set may look like this

Client	Field
a	apple
b	orange, apple
c	apple, orange
d	orange, other
e	burger

my result should be: 4 as their are 4 rows containing at least the fruit I was looking for.

Any help appreciated,

thanks

[melimob1]

thank you so much!

[melimob1]

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]

Hi @melimob1 ,

That's right, || means OR. 

Best regards,

[melimob1]

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 · Accepted solution]

OR = ||

AND  = &&