KNOWLEDGE BASE

Conditional Dimension Filters using A Parameter in a Cube Data Source Cause the View to be Blank


Published: 26 Sep 2017
Last Modified Date: 26 Sep 2017

Issue

When using a dimension filter that uses a parameter in a condition, and the parameter was created by adding all values from a field, then Tableau Desktop returns no results.

Environment

  • Tableau Desktop 10.3 and older
  • MSAS

Resolution

Option 1

Upgrade to Tableau Desktop 10.4

Option 2

As a workaround, manually add in all values in the parameter.

Cause

Automatically adding all values from a field into a parameter saved the parameter values as references rather than literals. When using the parameter in the condition of a dimension filter, Tableau Desktop was comparing a dimension member to a reference rather than to a literal.
Did this article resolve the issue?