7 Replies Latest reply on Oct 31, 2018 12:18 PM by Joe Oppelt

    Can we specify value of "ALL" option in filter selection?

    Nysha Chen

      For example, if I have a filter (Airport Filter) and I have a measure (Target Enplanements), within the measure my formula is

       

      IF [Airport Filter] = "Airport 1"

      THEN Target1

      ELSEIF [Airport Filter] = "Airport 2"

      THEN Target2

      END

       

       

      Then based on the user's filter selection, I want to change the Target Enplanements that is displayed. The measure formula I have above works.

       

      However, I also want to add....

       

      IF [Airport Filter] = "Airport 1"

      THEN Target1

      ELSEIF [Airport Filter] = "Airport 2"

      THEN Target2

      ELSEIF [Airport Filter] = "ALL"

      THEN Target1 + Target2

      END

       

      Which does not have an effect on the "ALL" selection inside of the filter.

      Is there any way I can achieve a similar effect? I want to reflect a sum of Airport 1 and Airport 2's targets when the user selects "ALL"

       

      Thank you for your help!