KNOWLEDGE BASE

Filtering on a Field Common to Tables Related by a Cross Join


Published: 15 Apr 2021
Last Modified Date: 20 Apr 2021

Question

How to combine the members on a column that appears in two tables related by a cross join, so that the values appear in a single dimensional filter.

Environment

  • Tableau Desktop

Answer

Use the following calculation to combine all the values in both fields:
CASE [Order ID]
WHEN NULL THEN [Order ID (Table2)]
ELSE [Order ID]
END
Did this article resolve the issue?