count filtered text line

[Mgg]

Hi All,

I need to count the lines with specific word in a column containgingdiferents words.

I though to do something like: 
data1 = countx ( filter( table, table[column] = "*wordtofind*"), [column to count])

This measure working only if the wordtofind is the only value in the cell.... but I wanto to count also if part of a sentence or part of long word.

May help me?

Thx

[vojtechsima · Accepted solution]

Hi, @Mgg 
use something like this:

Activated = COUNTROWS(FILTER('Table', CONTAINSSTRING('Table'[Company], "See")))

This will look for "See" in Column "Company" in table "Table".

[Mgg]

I'm not sure is exactly what I need.

Looking in the following table I need to count the number of Prj if in column type there is the word see ...also if combine with other.

The result should be 3....so the yellow onr 🙂
Thx

[vojtechsima]

Hi, @Mgg ,

CALCULATE(
	COUNTROWS('Table'),
	CONTAINSSTRING('Table'[Company], "See") && NOT (ISBLANK('Table'[Prj]))
)