topic Re: MEASURE - CONTAINSTRING - MULTIPLE TEXT in DAX Commands and Tips

MEASURE - CONTAINSTRING - MULTIPLE TEXT

melimob1 — Mon, 28 Oct 2024 13:25:52 GMT

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

Re: MEASURE - CONTAINSTRING - MULTIPLE TEXT

melimob1 — Mon, 28 Oct 2024 13:30:57 GMT

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

Re: MEASURE - CONTAINSTRING - MULTIPLE TEXT

DataNinja777 — Mon, 28 Oct 2024 15:11:16 GMT

Hi melimob1 ,

That's right, || means OR.

Best regards,

Re: MEASURE - CONTAINSTRING - MULTIPLE TEXT

melimob1 — Mon, 28 Oct 2024 16:02:21 GMT

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?

Re: MEASURE - CONTAINSTRING - MULTIPLE TEXT

gmsamborn — Mon, 28 Oct 2024 17:00:06 GMT

OR = ||

AND = &&

Re: MEASURE - CONTAINSTRING - MULTIPLE TEXT

melimob1 — Mon, 28 Oct 2024 19:03:55 GMT

thank you so much!