KNOWLEDGE BASE

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: 21 Apr 2020

Question

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

Environment

  • Tableau Desktop

Answer

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

Formula:


If [Multi-Search] = ""
OR
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?