Don't show visual if too many rows--cannot find a way to do this

[ThomasDay]

Hello all,

I am really finding the visual level filtering pretty difficult to manage.  The situation I'm dealing with is surely common.  A user uses slicers to find a selection to view--a series of visuals show the data.  But what if it's a ton of data--say the slicers are sequential -- it's possible to start big and narrow things down.   At some point you'd like to see the results.  

In my case, users can pick owner type (Govt, Investors, NotForProfit), attribute (Urban, Rural), Size (5 ranges of sizes).  The starting point is a slicer clear-all (i.e. no filter) and there are 5000 rows to show!!  I'd like to show things when the counts are below 1000 (not to mention that on Powerbi.com, the visual can't handle all the data.

The visual is a table--with 10 columns.  All are table columns--text and ONE AVG(numeric).

I am unable to get a visual level filter to work if there are more than 1000 rows.  I've tried the following code--putting each in the visual level filter and using advanced filter to say <1000 (or =Y) for TooManyFacilSlicerCheck.  Nothing happens...  What am I missing?  Thanks!  Tom

ReptRecNoCount = COUNTROWS(ReptRecNoProviderStage1Export)

TooManyFacilSlicerCheck = IF(CALCULATE(DISTINCTCOUNT(ProvidersStage1Export[Hospital_Name]),
ALLSELECTED(ProvidersStage1Export[Hospital_Name]))< 600,"Y","N")

ReptRecNoCount= If(ISFILTERED(ReptRecNoProviderStage1Export[Ownership]), COUNTROWS(ReptRecNoProviderStage1Export))

[chrisu · Accepted solution]

Try adding an ALLSELECTED filter to your first measure with the table as the argument:

ReptRecNoCount = CALCULATE(COUNTROWS(ReptRecNoProviderStage1Export),ALLSELECTED(ReptRecNoProviderStage1Export))

The table rows themselves are setting a filter context for COUNTROWS, so that for each row [ReptRecNoCount] evaluates to 1.  Adding ALLSELECTED with the table as the argument (not a single column) should override that and recalculate correctly based on  slicer selections.  

[ThomasDay]

Thanks very much, AllSelected is a great catch--and using the magical Calculate to get it done...  It works.  Nicely done.  Tom