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

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:

Refresh the extract to make the expected values appear.
Or, use a calculated field that mimics the behavior of the set, instead of a set.
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.