11 Replies Latest reply on Oct 26, 2018 3:14 PM by Sree B

    CASE WHEN on Measure Names

    Sree B

      Hi,

      How do i write a condition like below.

       

      CASE [MEASURE NAME]

      WHEN "EMPTY "  THEN " "

      WHEN "EMPTY1"  THEN " "

      ELSE  REGION

      END

       

      Note: EMPTY1 & EMPTY are Meaures Names

       

      My requirement is : In the attached twbx file, i need the REGION to be BLANK when Measure Names Belongs to EMPTY & EMPTY1 ELSE It should be HOST_REGION.