2 Replies Latest reply on Apr 9, 2016 4:23 AM by Alexis Jensen

    Update measure with multiple parameters

    Alexis Jensen

      Hi,

       

      I have a table with a number of products with a measure "Prices".  Is there a way to update this measure (or a substitute measure) using a parameter for each product?  I am using the data in a calculation but I need the end user to be able to update the prices on the dashboard.

       

      I am open to any solution that will work for this.

       

      Thanks in advance/

       

      Regards,

      Alexis

        • 1. Re: Update measure with multiple parameters
          kumar.c

          Hi Alexis,

           

          Is your prices measure field coming from data source?

          Do you want the user to enter the value so the Prices value will change accordingly like:

          Prices *parameter value is that what you are looking for?

           

          If that is the requirement then follow below steps:

          1. Create parameter with data type as integer and keep it as All.

          2. Create calculated field and in that add Prices * Parameter

          3. Drag this calculated field on to the row shelf or column shelf and right click on the parameter and show parameter control.

           

          So based on the user input the chart will change accordingly.

          I hope it is what you are looking for.

          • 2. Re: Update measure with multiple parameters
            Alexis Jensen

            Hi,

             

            What you are describing is not quite what I need. I have a table as per below and I need to able for the price to be user updateable.  The other fields are fixed and the calculated field = ([Price]-[Cost])*[Yield].  I don't want to have to create an individual calculated field per product / parameter.  Is there a way to update the price for A to E?

             

             

            ProductPriceCostYieldCalc
            A100100.054.5
            B3002501.575
            C200500.4567.5
            D2001000.7575
            E100250.2518.75

             

            Regards,

            Alexis