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

    MDX case expression - help


      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


            CASE [Color]

            WHEN 'Blue' THEN 'B'

            WHEN 'Red' THEN 'R'

            WHEN 'Green' THEN 'G'



      I am missing something here and getting error.


      Jonathan Drummey Pooja Gandhi Andy Kriebel