Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Dynamic Measure (% based)

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?  

1 ACCEPTED SOLUTION
jaideepnema
Solution Sage
Solution Sage

Hi @Anonymous 

Create a What If Parameter like this 

jaideepnema_0-1613140294489.png

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 

https://we.tl/t-KyJoNTDIxp

 

Please accept this as a solution if your question is answered !!

Appreciate a Kudos 😀

View solution in original post

4 REPLIES 4
jaideepnema
Solution Sage
Solution Sage

Hi @Anonymous 

Create a What If Parameter like this 

jaideepnema_0-1613140294489.png

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 

https://we.tl/t-KyJoNTDIxp

 

Please accept this as a solution if your question is answered !!

Appreciate a Kudos 😀

Anonymous
Not applicable

Works perfect!  Thanks!

Anonymous
Not applicable

Yes, having the final price adjust based on that slicer value.

jaideepnema
Solution Sage
Solution Sage

Hi @Anonymous 
Is this what you are looking for ?

jaideepnema_0-1613111601860.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors