Hide data in a matrix if zero required filters are set

[sandyteenan]

Hi all,

I have 2 tables with a 1-many relationship. The filter on the 1 side is set to "require single selection", but it's possible to unselect all which causes all data to be displayed. Leaving aside the insanity of this implementation 😋, how can I hide all data if zero filters are selected? HASONEFILTER in a measure gives me the information I need but a visual level filter on that measure (IsFIlteredCorrectly in the screenshot) will not allow me to specify filter out anything - (All) is the only option.

Is there a way to do this?

[sandyteenan]

 Data for Capital table : 

IsCapital

1

0

Data for Population table : 

Country	City	IsCapital	Population
England	London	1	6000000
England	Manchester	0	3000000
Scotland	Edinburgh	1	600000
Scotland	Glasgow	0	1000000

[amitchandak]

@sandyteenan ,  Try a measure like this and check in the visual level filter if that 1

Measure = if(CALCULATE(HASONEVALUE('Table'[IsCapital]),ALLSELECTED()) && Maxx(ALLSELECTED('Table'[IsCapital]), 'Table'[IsCapital])=0, 0,1)

I have done that on brand id

Measure = if(CALCULATE(HASONEVALUE('Item'[Brand]),ALLSELECTED()) && Maxx(ALLSELECTED('Item'[Brand Id]), 'Item'[Brand Id])=1, 0,1)

[sandyteenan · Accepted solution]

Thanks for the pointer @amitchandak - for the purposes of the demo above, the measure should be :

IsFilteredCorrectly = if(CALCULATE(HASONEVALUE('Population'[IsCapital]),ALLSELECTED()) , 1,0)

Which correctly displays nothing if all filter values for IsCapital are unchecked and only the subset of rows if one of the filter values is selected 👍