KNOWLEDGE BASE

Displaying a Different Measure Based on Hierarchy Drill Level


Published: 25 Sep 2014
Last Modified Date: 01 Nov 2017

Question

How to change which measure is displayed based on the level where the user has drilled into the hierarchy.

Environment

Tableau Desktop

Answer

Use a calculated field similar to the following:
IF MIN([Hierarchy Level 3]) = MAX([Hierarchy Level 3]) 
THEN [Measure 3] 
ELSEIF MIN([Hierarchy Level 2]) = MAX([Hierarchy Level 2]) 
THEN [Measure 2] ELSE [Measure 1] 
END
Did this article resolve the issue?