Forum Discussion
Solved
Custom visual text input (search)
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 |
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
1 Reply
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