Forum Discussion

Mgg's avatar
Mgg
Icon for Helper I rankHelper I
4 years ago
Solved

count filtered text line

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*"), [colum...
Need Help
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    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".

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
4 years ago

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's avatar
Mgg
Icon for Helper I rankHelper I
4 years ago

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's avatar
    vojtechsima
    Icon for Super User rankSuper User
    4 years ago

    Hi, Mgg ,

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