Forum Discussion

mhr08004's avatar
mhr08004
Frequent Visitor
2 years ago
Solved

Numeric Parameter Input to Table Row

Hello All,

 

I greatly appreciate you assistance here...

 

I would like to input a specific parameter value into a table row as below. 

 

I have this working fine with the exception of referencing it in a specific row. 

 

I am completly coming up blank here, happy to make a datatable from the parameters and join them or do a direct measure.

 

The idea here is to take the current value of a catagory and map a what-if through the partamater to model a future outcome.

 

 

  • Hi mhr08004 
    That's not a problem 🙂

    You can create 2 parameters and use them inside a simple if expression :

    The updated pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

     

3 Replies

    • mhr08004's avatar
      mhr08004
      Frequent Visitor

      Hello,

       

      Thank you for the reply. However, this is not the answer to the question. The soluiton provided gives a % discount to all products in the table. I would like the discount to only be provided to say, 'Product 1', then have a second discount slicer for 'Product 2', and so on. 

       

      The measure will need to only target specific rows in the table. 

      • Ritaf1983's avatar
        Ritaf1983
        Super User

        Hi mhr08004 
        That's not a problem 🙂

        You can create 2 parameters and use them inside a simple if expression :

        The updated pbix is attached

        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly