Disabling a filter for a particular table

[Luffy20]

Hi

I had two tables and some filters in a sheet, while i am using filters the one table should not have to respond.

My measure is Count({$<[VZI (Yes/No)]={'Yes'},Band={'6V'}>}distinct[Full Name])/count(distinct([Full Name]))

and filed used in my filter is [Loaction],can anyone help me with my logic.

Thanks

[TauseefKhan · Accepted solution]

Hi @Luffy20,

If one of your tables does not respond to selections made in the [Location] field, you can modify the set analysis in your measure to ignore selections in that specific field.

Count({$<[VZI (Yes/No)]={'Yes'}, Band={'6V'}, [Location]=>} distinct [Full Name]) / Count({<[Location]=>} distinct [Full Name])

 *** When applicable please mark the correct/appropriate replies as "solution". Please LIKE threads if the provided solution is helpful to. ***