3 Replies Latest reply on Jul 13, 2016 8:23 AM by Felix Lutterbeck

    Create new measure dependent on dimension coming from parameter

    Felix Lutterbeck

      Hi all,

       

      I am trying to create a new measure from an existing measure that is conditional on two dimensions which I would like to select via parameters.

      Here is an illustration of what I would like to do:

       

      My data has prices for different fruits on different dates. The measure here is price and dimensions are fruitname and date. I have also created two parameters which allow me to select two different type of fruit.

       

      I would now like to create a new measure which calculated the price difference of the two fruits I have selected via the parameters. The result of which should look like the yellow-shaded fields below.

       

      Thanks for your help!

      Example.PNG