Custom visual text input (search)

[badger123]

Hello, I am using the text filter visual. Is it possible to count how many times the text typed into the search bar appears? E.g. If I enter"red" into the search bar in this case the output would be 2... 

blue red yellow green

blue yellow

orange

purple red

[v-danhe-msft · Accepted solution]

Hi @badger123 ,

Based on my test, you could refer to below formula:

a = CALCULATE(COUNTROWS('Table1'),FILTER(ALL(Table1),SEARCH("red",CALCULATE(MAX('Table1'[Name])),,BLANK())<>BLANK()))

Result:

You could download the pbix file to have a view.

Regards,

Daniel He