Only show data on visual if underlaying data contains more than 10 rows

[PH9Z]

I want to show only data if the table (after filtering) has more then 10 rows.

I treid

Check10 = COUNTROWS('TABLE')

 this indeed gives me a rowcount but a 'all pages filter ' >= 10 filters out all data.

Any suggestions?

[Mariusz]

Hi @PH9Z 

Try this,

Measure = 
COUNTROWS( ALL( 'Table' ) )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[PH9Z]

Hi Mariusz,

This gives the totaal rowcount before filtering, I need to filter on the total number of rows after filtering:

Total = 5 the total number of rows here is 5, so I don't want to show the visiual. If the total is equal or greater the 10 I want to show it.

[Mariusz · Accepted solution]

Hi @PH9Z 

Sorry use ALLSELECTED instead of all, and add this Measure to "Filters on this visual" in the filters Pane

Measure = 
COUNTROWS( ALLSELECTED( 'Table' ) )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

and if you use VALUES? 

Measure = COUNTROWS(VALUES('Table'))

[PH9Z]

Hi Jef,

I'm not able to drag this measure on the filter pane and edit it... I can't enter any value: