KNOWLEDGE BASE

Using Sets in Calculated Fields


Published: 16 Feb 2018
Last Modified Date: 16 Feb 2018

Question

How to use sets in calculated fields.

Environment

Tableau Desktop

Answer

Sets return either TRUE for all members in a set, and FALSE for all members out of the set. Because sets already return TRUE or FALSE, the set is the only thing needed in the conditional statement.
For example, the following calculation:

IF [Customer Name] = [Set 1]
THEN 1
END


could become:

IF [Set 1]
THEN 1
END
Did this article resolve the issue?