KNOWLEDGE BASE

Including Filters in Calculations Without Including them on the Filter Card


Published: 30 Nov 2015
Last Modified Date: 25 Jul 2016

Question

How to include filters in calculations without including them on the filter card. 

Environment

Tableau Desktop

Answer

Create a logic calculation by using an IF / THEN statement to return a measure for only certain dimension values. See an example of a calculated field below: 
If [Color] = "Yellow"
Then [Size]

End

The example returns the field [Size] for rows of data with the color value of Yellow. [Size] could be replaced by a different field in the formula to return something different.
Did this article resolve the issue?