Value not showing from measure in text box

[aausten22]

Hi All, 

I am using a text box which will then change the values in certain places depending on the slicer - this works great

The issue is that I am trying to use a measure that counts the amount of times a certain value shows up and now it comes up with a little icon that its not working (see below).

Here is the formula for the measure - I am ideally wanting it to count multiple values which are "21-30","31-40" & "40+"

HighLeaveBal = CALCULATE(COUNTROWS('Data Set - Leave Liability'),SEARCH("21-30",'Data Set - Leave Liability'[Total Day Range],,0))

Have tried a few different ways of doing it though its not coming up

[amitchandak · Accepted solution]

@aausten22 , You should in if the values are absolute or Search with OR

HighLeaveBal = CALCULATE(COUNTROWS('Data Set - Leave Liability'),Filter('Data Set - Leave Liability',  SEARCH("21-30",'Data Set - Leave Liability'[Total Day Range],,0) ||

SEARCH("31-40",'Data Set - Leave Liability'[Total Day Range],,0) ||
SEARCH("40+",'Data Set - Leave Liability'[Total Day Range],,0)

) )

or

HighLeaveBal = CALCULATE(COUNTROWS('Data Set - Leave Liability'),Filter('Data Set - Leave Liability',  'Data Set - Leave Liability'[Total Day Range],,0) in {"21-30" ,"31-40",' "40+"}

) )

[aausten22]

I went through the data and looks like for that one filter there are no records - how can I get it to display a 0 if there is nothing there?

[aausten22]

I have tried both of these and they are both not working.

The first one comes up with the same issue and the second one just errors the whole text box

Thank you for your efforts though!