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


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.


  • Tableau Desktop
  • Tableau Data Engine


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 


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?