KNOWLEDGE BASE

Unselecting all Values in a Cube Filter Still Shows Data in the View


Published: 18 Dec 2017
Last Modified Date: 05 Jan 2018

Issue

Unselecting multi-select filter leaves data displayed in the worksheet. 

Environment

  • Tableau Desktop 10.4.0 - 10.4.2
  • Microsoft Analysis Services (MSAS)

Resolution

Option 1

Upgrade to Tableau Desktop 10.4.3.

Option 2

If upgrading is not possible, as a workaround remove the condition formula from the filter, since the condition should still be applied from the condition formula of the set.

Cause

Using MSAS as a data source, if the same formula condition is defined on both a filter and its underlying set, deselecting (All) will fail to exclude members. This is a known issue (720227) that has been fixed in later versions of Tableau Desktop.

Additional Information

The filter comes from a set with a conditional formula, and the filter will contain the same exact conditional formula.
Did this article resolve the issue?