4 Replies Latest reply on Jan 29, 2019 5:14 AM by Tim Dines

    MDX case expression - help

    kumar.c

      Hi All,

       

      I need help in writing a MDX (SSAS) case expression in Tableau. I have dimension with some values and my requirement is to show some custom values based on the existing field/dimension, like example:

       

      Dimension is the existing field  "Color" and it has values like Blue, Red and Green

       

      WITH MEMBER [Measures].x

         AS

            CASE [Color]

            WHEN 'Blue' THEN 'B'

            WHEN 'Red' THEN 'R'

            WHEN 'Green' THEN 'G'

            END

       

      I am missing something here and getting error.

       

      Jonathan Drummey Pooja Gandhi Andy Kriebel