Values for Calculated Field Based on Set Do Not Update As Expected

Published: 15 Jun 2016
Last Modified Date: 11 Jan 2018


When using a calculated field based on a set, values for the calculated field do not always update after the set is modified.


Tableau Desktop 10.4.0 and earlier versions


Upgrade to Tableau Desktop 10.5.0 or a newer version. For more information, see Upgrade Tableau Desktop

If you are unable to upgrade, try one of the following workarounds: 

Option 1:

Refresh the extract to make the expected values appear.

Option 2:

Use a calculated field that mimics the behavior of the set, instead of a set.

Option 3:

Create a "Dummy Variable" that is inserted in a the formula for the Calculated Field, providing a 'direct reference' to a parameter.
For example,
Original formula:

       IF [Set 1] THEN [Sales] END

Where "Set 1" is a Set defined by a condition formula that references a parameter.
Revised formula: 

 IF [Set 1] THEN [Sales] END * [Parameter_One]

Where "Parameter_One" is a Parameter with a values of 1.



This behavior is related to a known issue with ID 667919 which has been corrected in more recent versions.


Additional Information

Did this article resolve the issue?