- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Percentage calculation based off of a range of numbers
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi would this not just divide all amounts by 10?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You can create a new column like
Switch( True(),
[Amount] = 100, .1 ,
[Amount] = 60, .06 ,
0
)
Modify as per need
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
68 | |
58 | |
51 | |
36 | |
34 |
User | Count |
---|---|
84 | |
71 | |
56 | |
45 | |
43 |