KNOWLEDGE BASE

Filter Members With No Data


Published: 16 Feb 2017
Last Modified Date: 17 Feb 2017

Question

How to filter out field members that do not have any data for a measure in the view.

Environment

Tableau Desktop

Answer

  1. Select Analysis > Create Calculated Field. name the field, enter the following formula, then click OK:
    [Measure]>0
  2. Place the newly created calculated field on Filters on each worksheet you would like to filter.
  3. Select True and click Ok.
Did this article resolve the issue?