1 Reply Latest reply on Aug 17, 2018 1:32 PM by Patrick A Van Der Hyde

    Calculated Field that selects a Measure according to Parameter

    Hans-Joachim Kunz

      Hi all,

       

      I am trying to find an efficient/less tedious way to implement the following calculated field.

      Tableau-Calculated-Field-for-Dimension-Choices.png

      While this approach leads to the desired result, it is not ideal if the list of possible 'WHEN' cases becomes very long or the calculated field has to be implemented repeatedly.

      Another issue would be if additional possible cases are added as Fields and all existing calculated fields have to be updated.

       

      Thank you very much in advance!

       

      Best,

      Hans-Joachim