Use Conditional Statement to Filter Rows

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


How to filter rows using a conditional statement.


Tableau Desktop


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


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?