Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello,
I have a report which uses the 'text filter' visual to search for specific text within a field, and filter the report accordingly. This all works very effectively. The text filter visual filters a matrix from which they can see the responses they need.
I have received a request for the user to be able to search for a piece of text, and then have a visual which counts the number of times the text they have searched appears in the relevant field. I have struggled to figure out an effective way to do this, has anyone came across a similar scenario? I know how to do this with static values that I could add in a measure, but not for ones that a user defines. Any tips would be appreciated!
Thank you
Solved! Go to Solution.
Try this measure:
Count Values = COUNTROWS ( Table1 )
The COUNTROWS function will count the number of rows that contain the search term in the Text Filter visual.
Proud to be a Super User!
Try this measure:
Count Values = COUNTROWS ( Table1 )
The COUNTROWS function will count the number of rows that contain the search term in the Text Filter visual.
Proud to be a Super User!
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 20 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 60 | |
| 52 | |
| 47 | |
| 40 | |
| 38 |