Forum Discussion

Mgg's avatar
Mgg
Helper 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*"), [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

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

3 Replies

  • vojtechsima's avatar
    vojtechsima
    Super 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
      Helper 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
        Super User
        4 years ago

        Hi, Mgg ,

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