Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
melimob1
Helper I
Helper I

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

 

 data set may look like this

ClientField 
aapple 
borange, apple 
capple, orange 
dorange, other 
eburger 

 

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

 

Any help appreciated,

thanks

 

1 ACCEPTED SOLUTION

OR = ||

AND  = &&



Proud to be a Super User!

daxformatter.com makes life EASIER!

View solution in original post

5 REPLIES 5
melimob1
Helper I
Helper I

thank you so much!

melimob1
Helper I
Helper I

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

Hi @melimob1 ,

 

That's right, || means OR. 

 

Best regards,

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?

OR = ||

AND  = &&



Proud to be a Super User!

daxformatter.com makes life EASIER!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.