filtering - Can I turn off a condition in a Tableau filter?

Question

I have a carrier list for which we're disqualifying carriers who have done more than 90% of deliveries for one customer. So I have a custom field built for that. However, if I just apply a parameter to filter out 0 in column 5, it is only going to filter out those CUSTOMERS that are at 90 + percent of deliveries. However, I need to filter out CARRIERS who meet that condition with any one customer. See image1 below. Carrier 1MTX LLC would still show up in the view, even if I filter out the 0. Thus the conditional filter on carrier name that you see pictured in image below.

I need to be able to allow a user to turn this condition off or on, based on what view is needed. Some users will want to be able to see all carriers, regardless of whether or not they've met qualification guidelines, while others will just want to see qualified carriers. Any ideas on how I could toggle the actual condition of the filter on or off? I can't share my workbook.

I ended up doing this. I created a column which I will hide in the view that partitions by carrier and customer, restarting at each carrier, that displays the MAX value of Customer % of Volume. Then I created a True/False filter so that users can filter on the hidden column.

Answer 1

I was making this a lot harder than it needed to be. I ended up just creating a table calculation on the Customer % of Volume Field (which I will hide in the view) that displays MAX(Customer % of Volume), partitioned by carrier and customer. Then I created a True/False filter for users. That way, they can filter on the hidden column.

Thank you for the replies though.