Configure A Filter To Apply To A Measure And Do Not Apply To Another Measure In The Same Sheet

Published: 21 Apr 2020
Last Modified Date: 08 Jul 2022


Configure a filter to apply to a measure and do not apply to a measure having Fixed LOD in the same sheet.
Example: Apply category filter for weekly listings and do not apply to total listings for the week


  • Tableau Desktop


Option 1 : Use a dashboard

Dashboard with different sheets having total listings and filtered listings and then configure the filter to apply to specific sheet and deselect the total listings sheet

Option 2 : Use a parameter 

1) Create a Parameter:

Name : Multi-Search
String as a data type

2) Create a calculated field:

Name: Filter listings


If [Multi-Search] = ""
CONTAINS([Multi-Search],[Agency]) then   ([Listingid]) end

3) Show the parameter control 

4) Type the values in parameter you want to filter

Did this article resolve the issue?