countrow when blank returned

[sanjanarama]

I have a filter and want to display count of rows returned after search. but im not able to figure out how to write condition if blank is returned from count rows 

Total Rows = IF(ISFILTERED ('table'[Search]),COUNTROWS('table')  &  " customer match(es) found.", "No customer match(es) found.")

before any search is performed im displaying below 

[sanjanarama · Accepted solution]

In case if anyone is looking for solution, i did figure out

1) first create measure to get total rows and return 0 if no rows

TotalRowsCount = IF (CALCULATE ( COUNTROWS('Table') ) = BLANK (),
0,

CALCULATE ( COUNTROWS('Table') )

)

2) create below measure to get the display 
Total Rows = IF( ISFILTERED ('Table'[Search]) ,'Table'[TotalRowsCount] & " customer match(es) found.", "No customer match(es) found." )

[amitchandak]

@sanjanarama , If you trying this for the search of a standard slicer, I doubt that. This can work with text search

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview

[sanjanarama]

@amitchandak  
I'm using same slicer, the measure which is posted im displaying it if my table returns a result after search from slicer

[amitchandak]

@sanjanarama , using text filter I tried this and it worked. On my data

Measure = if(ISFILTERED('Item'[Brand]), "Selected in " & Distinctcount('Item'[Brand]) , "Not selected")
 
or

Measure = if(ISFILTERED('Item'[Brand]), "Selected in " & CONCATENATEX(distinct('Item'[Brand]),[Brand]," ,") , "Not selected")

[sanjanarama]

but if a text is searched which is not in dataset it returns as below, it should display "0 customer match(es) found", how do we achive that