Numeric Parameter Input to Table Row

[mhr08004]

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.

[Ritaf1983]

Hi @mhr08004 
Yes, you can create what-if parameters.

Please refer to the linked tutorial:

https://www.youtube.com/watch?v=28PDdA3SROU

+

I attached pbix with my example, you can download it and see how it works

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

[mhr08004]

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 · Accepted solution]

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