Showing blank table when not filtered by Text search Slicer

[TerCh]

Hi

I have tried to filter a large table not to show anything before someone enter a search.

I have tried to measure the different between

NoSeach = CALCULATE(COUNT(Materials[Material]),ALLEXCEPT(Materials,Materials[Cross-distribution-chain material status]))

and 

NoSearch2 = COUNTROWS(SUMMARIZE(Materials,Materials[Material]))

NoSearch3 = IF([NoSeach]=[NoSearch2],1,0)  (1 is no search, 0 is search)

This work and I get same figure when no search and diff figure when having a search (filter)

I have many search fields with visualizations "Text search Slicer".

See picture

 but when trying to set the switch in filter pane =0, nothing happens

Any ideas what to do here?

[TerCh]

Hi, thanks for your comment. The reason why is that the table is large and take long time to load. To minimize this time I hoped there would be a method when nothing is selected or all is selected (because that will never be a case) the table do not load (or can be filtered empty). As soon there will be a seach (filter) then filtering will act as usual.

[lbendlin]

The DAX query for your table visual automatically adds a TOPN(501,...)

[lbendlin]

I have tried to filter a large table not to show anything before someone enter a search.

Why?  You are setting the stage for your users in a passive-agressive way. They will not appreciate that.

Remember that in Power BI "nothing selected"  is the same as "everything selected".*  You may be fighting windmills here...

* yes, yes, there are some nuances to that, There's a subtle difference between "nothing selected yet"  and "nothing selected any more".