Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 ?
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |