Changing a Price of a stock to calculate shares

[Anonymous]

Hi folks,

I have a few measures:

2019 Stock Shares Value = 'Equity'[2019 Shares]*17

2020 Stock Shares Value = 'Equity'[2020 Shares]*17

2021 Stock Shares Value = 'Equity'[2021 Shares]*17

We anticipate the stock price of those measures to be $17. However, what I want to do is give the user a chance to use one slicer to change the amount from $17 to some other value. 

I would want the values to be from $17-$25, but if they selected a price, I would want the price to change all 3 measures in the table or pivot visual. 

What's the best way to do this? I've tried searching and can't seem to find anything. 

Many thanks. 

[AkhilAshok · Accepted solution]

Why don't you try the What If Parameter option in Power BI (Modeling -> New Parameter). You can create a parameter, with minimum value 17 & maximum value 25. Then you can replace 17 in all your measures with the [Parameter Value] measure.

[Anonymous]

@AkhilAshok Oh. Em. Gee. I forgot about that! You're right. I forgot about how easy that is to do. Thank you 🙂