KNOWLEDGE BASE

Filtering a Data Source with a Conditional Calculation


Published: 13 Sep 2017
Last Modified Date: 13 Sep 2017

Question

How to use a conditional calculation in a data source filter.

Environment

  • Tableau Desktop

Answer

Create a conditional calculation in a worksheet, then add the calculation to the data source filter, for example:
[Category] = 'Furniture' AND [Segment] = 'Corporate'
OR
[Category] = 'Furniture' AND [Segment] = 'Home Office'

 

Additional Information

When adding a data source filter, a condition cannot be created in the "Add data source" filter dialogue. However, a conditional calculation can be added to the data source filter.
Did this article resolve the issue?