Containsstring not working how I want it to

[Jonathan47]

Hi, 

I have a column of text of which have multiple text in some of the cells. I want to know how many times (in this case) inverter 02.1 appears in the column. The table is as shown below:

My measure is:

Contains =

CONTAINSSTRING(SELECTEDVALUE(KIX[Name]), "Inverter 02.1")

Apologies if hard to see, but in the Name column, Inverter 02.1 appears several times, yet the measure returns false for that row. Does anyone know what the problem is?

Thanks

[amitchandak · Accepted solution]

@Jonathan47 , try like, measure

Contains =
CONTAINSSTRING(Max(KIX[Name]), "Inverter 02.1")

column

Contains =
CONTAINSSTRING(KIX[Name]) "Inverter 02.1")

[Greg_Deckler · Accepted solution]

@Jonathan47 - If you want to know how many times that word/phrase appears in your text, do it this way:

Contains Column = IF(FIND("Inverter 02.1",[Name],,-1)>-1,1,0)

Contains Measure = IF(FIND("Inverter 02.1",MAX([Name]),,-1)>-1,1,0)

[amitchandak · Accepted solution]

@Jonathan47 , try like, measure

Contains =
CONTAINSSTRING(Max(KIX[Name]), "Inverter 02.1")

column

Contains =
CONTAINSSTRING(KIX[Name]) "Inverter 02.1")

[Jonathan47]

Thanks! the second solution works for me.