How to display count of search results with Text Filter and Text Slicer Filter

[clarawang_12]

Dear Community,

I'm using Text Filter and Text Slicer Filter to search contents of power BI page, is there a way to show the count of search results? For example, search "Content A" in Text filter, and a card or message will show how many "Content A" in this page.

Kind regards,

Clara 

[v-binbinyu-msft · Accepted solution]

Hi @clarawang_12 ,

Please try below steps:

1. below is my test table

Table:

2. add a tabl visual with fields, and add  a text filter with field

3. create a measure with below dax formula

Measure =
VAR pt =
    SELECTEDVALUE ( 'Table'[Product] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), CONTAINSSTRING ( [Product], UPPER ( pt ) ) )
RETURN
    IF ( ISFILTERED ( 'Table'[Product] ), COUNTROWS ( tmp ), 0 )

4. add a card visual with measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@clarawang_12 , if test filter is applied in page

then countrows(Table)

or countrows(Table, Table[Column], "_1", [Measure]))

should give you the filtered count.

Or try

CONTAINSSTRING and CONTAINSSTRINGEXACT: https://www.youtube.com/watch?v=XbgLGDvWdWQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=44

SEARCH and FIND: https://www.youtube.com/watch?v=mZt0HJw4gjQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=45