KNOWLEDGE BASE

Unexpected Results on the View When Using Calculated Fields or Sets Based on a User Filter


Published: 02 Mar 2017
Last Modified Date: 01 Jun 2017

Issue

When a user filter is applied using a calculated field to evaluate two separate sets, the view is not updated until it is manually refreshed.

Environment

  • Tableau Desktop
  • Tableau Data Engine

Resolution

Option 1

Upgrade to Tableau Desktop 10.3. For more information, see Upgrading Tableau Desktop.

Option 2

Use a Combined set instead of checking single sets separately in the calculated field

Option 3

Use ISMWEMBEROF. For example: 
If ISMEMBEROF("Group1OnTableauServer") then 
if [Set1 ] and [Set2] then 1 else 0 END 
ELSEIF ISMEMBEROF("Group2OnTableauServer") then 
if [Set1] and [Set2] then 1 else 0 END 
END 

Cause

This behavior is related to a known issue (ID: 616116) that has been fixed in a later version of Tableau Desktop. 
Did this article resolve the issue?