KNOWLEDGE BASE

Dimension Filter Values for Data Sources Containing an Inner Join


Published: 01 Apr 2021
Last Modified Date: 01 Apr 2021

Issue

When used with a data source that has an inner join, an interactive filter shows the domain from the underlying table (all values in database), instead of the values that result from the inner join.

Environment

  • Tableau Desktop

Resolution

To limit the filter values to just those resulting from the inner join, try the following workaround:

1. Create a calculated field [Show Relevant Data] using the following calculation (where [Order ID] is the field used for the filter):
IF ISNULL([Order ID]) THEN FALSE ELSE TRUE END

2. Drag [Show Relevant Data] to the Filters shelf, select 'True' and click 'OK'.

3. Right-click [Show Relevant Data] on the Filters shelf, and select 'Add to Context'.

4. Select the 'All Values in Context' option for the filter card.
Did this article resolve the issue?