Specifying a Default Filter When Action is Cleared

Published: 08 Jun 2018
Last Modified Date: 18 Sep 2020


How to default to a specified dimension member when an action filter is cleared.


  • Tableau Desktop


  1. Create a calculated field that filters to the specified dimension member when no filters are applied.
  2. For example, to set "Washington" as the default filter when the action is cleared, place the following calculation on the Filters Shelf and keep only TRUE:
MIN({FIXED: COUNTD([State])}) <> MIN({EXCLUDE [State],[City]: COUNTD([State])})

Additional Information

  • The table-scoped FIXED LOD ignores the filter, so it always returns the unfiltered amount of members
  • The EXCLUDE LOD does not ignore the filter, so it returns the filtered amount of members
  • If those values are equal, nothing is filtered
  • If nothing is filtered, only keep records where [State]="Washington"

Discuss this article... Feedback Forum
Did this article resolve the issue?