KNOWLEDGE BASE

Use Conditional Statement to Filter Rows


Published: 09 Oct 2014
Last Modified Date: 10 Sep 2017

Issue

How to filter rows using a conditional statement.

Environment

Tableau Desktop

Resolution

  1. Create a calculated field.
  2. Use an IF/THEN statement in the formula.
  3. Place the field on the view.

Cause

Tableau Desktop will filter out values before aggregating the data.

Additional Information

When filtering using the filters shelf, Tableau Desktop will filter all of the marks associated with the dimension member at the lowest level of aggregation. Using the IF/THEN statement method above will remove certain measure values from the view before the values are aggregated at the level of detail in the view.
Did this article resolve the issue?