12 Replies Latest reply on Apr 9, 2020 7:22 AM by Raj Cheruvu

    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.