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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.