Return count of cells that contain a certain text

[DJsummers]

Hi, 

I have a very large table and the part I am interested in is the value_2 column

I would like a measure where I can search and count this column for any mentions of "House 1" and then a seperate measure to search for any mentions of "House 2", etc etc.

Once I have this, I can then use the built in basic filters to get what I want but I am falling down here. I have tried varying formulas on these forums but I can't make any work for me.

I am also too embarassed to say but the latest one I have tried is:

Any help offered would be greatly appreciated!
Dan.

[Samarth_18 · Accepted solution]

You can create a measure with below code

 Measure 3 = CALCULATE(COUNT(Search_data[value]),CONTAINSSTRING(Search_data[value],"house1")) 

My sample table data:-

  

Output:-