Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
OR = ||
AND = &&
thank you so much!
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
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 = &&
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |