Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have to think this is out there but not finding anything that macthes yet.
I have a table of items with a price field and I'm looking to do a measure based on a slider being used to select the % of the calculation. For example:
Slider has values of 1% through 10%
other table has a list of items and a base price of the item.
I want to create a reactive price field based on an increase to be selected in the slider.
Doable?
Solved! Go to Solution.
Hi @Anonymous
Create a What If Parameter like this
Then Create a Measure like this
New Price =
var percentagechange='Percentage Change'[Percentage Change Value]/100
var percnetagechangeprice=percentagechange*sum('Price List'[Price])
var newprice=sum('Price List'[Price])+percnetagechangeprice
return newprice
Here is the link in case you want to download the file
Please accept this as a solution if your question is answered !!
Appreciate a Kudos 😀
Hi @Anonymous
Create a What If Parameter like this
Then Create a Measure like this
New Price =
var percentagechange='Percentage Change'[Percentage Change Value]/100
var percnetagechangeprice=percentagechange*sum('Price List'[Price])
var newprice=sum('Price List'[Price])+percnetagechangeprice
return newprice
Here is the link in case you want to download the file
Please accept this as a solution if your question is answered !!
Appreciate a Kudos 😀
Works perfect! Thanks!
Yes, having the final price adjust based on that slicer value.
Hi @Anonymous
Is this what you are looking for ?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
104 | |
77 | |
35 | |
35 |
User | Count |
---|---|
158 | |
103 | |
71 | |
65 | |
53 |