Percentage calculation based off of a range of numbers

[DylanBanINT]

Hi, I am looking to create a column on Power BI that will calculate a percentage of a number based on the 'score' it has so that it will create an 'expected savings' 

For example I have a table like this: 

Title	Score	Amount	Savings
Cookie	40	£100
Cake	60	£50
Sprite	20	£60
Cola	0	£250
Bread	100	£180
Baguette	60	£40
Slurpie	40	£55
Green Tea	20	£180

Based off the score I would like to calculate a percentage of 'savings' - If it has a score of 100 it will calculate 10% and if it has a score of 60 it will calculate 6% etc etc

[DylanBanINT · Accepted solution]

https://community.powerbi.com/t5/Desktop/Percentage-calculation-based-off-of-a-number-range/m-p/2719...

 for my specific solution

[amitchandak]

@DylanBanINT , Create a new column

= [Amount] /10

[DylanBanINT]

Hi would this not just divide all amounts by 10? 

[amitchandak]

@DylanBanINT ,

You can create a new column like

Switch( True(),

[Amount] = 100, .1 ,

[Amount] =  60, .06 ,

0

)

Modify as per need

[DylanBanINT]

Hi, is there a way to do it so it would be like if Score is 0-100 then Amount / 0-10%? So like a range