Show null when more than 1 criteria in a filter is selected

[ShellyG]

Hello guys, 

I would be very happy if I can get your assistance with something I am struggling with... 

I have a sheet with a couple of filters and a couple of visuals... I want to limit only one of the visuals to be showing null/empty/a specific message when more than one value is selected from the filters, as the data in this specific visual will only make sense if one selection is made in each of the filters. 

I don't want to limit the filter, because I need it to have the option to select more than 1 option for other purposes. 

I tried something like:

isNull(FilterName)>= 0 or 1, which kind of works, but I don't like the fact that it continues to show the visual if you make more than one selection in the filter and also the isNull works with only one parameter and I need something for two...

Thanks in advance!

[lorenzoconforti · Accepted solution]

You can use GetSelectedCount in your Calculation Condition option

if(GetSelectedCount(FilterName)<= 1,1,0)

You can then combine multiple if statements if you want to check on multiple filters

[ShellyG]

Thanks very much!