- Forums
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Integrations with Files and Services
- Mobile Apps
- Developer
- DAX Commands and Tips
- Let's Talk Data
- Custom Visuals Development Discussion
- Community Support
- Welcome to the Community
- Community Feedback
- Community Help Blog
- Training and Consulting
- Dashboard in a Day
- EdX Specific Training Discussion Forum

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Microsoft Power BI Community
- Forums
- Get Help with Power BI
- Desktop
- Calculate Percentage

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

ravsha85

Member

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-14-2017
09:55 PM

Hi, I am new to Power BI, can someone help me with calculating the percentage with the symbol % in it I have the below data, for which I have to find the total sum and display it in the percentage value.

Percent |

10 |

20 |

10 |

20 |

15 |

5 |

10 |

5 |

5 |

Thanks, Ravi

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

v-huizhn-msft

Super Contributor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-15-2017
11:12 PM

Hi @ravsha85,

You want to calculte the percentage of each value verse total value? For example, 10/(10+20+10+20+15+5+10+5+5), right? If it it, please create a calculated column using the following formula, and see the result shown in the following screenshot.

Percentage = Test11[Percent]/CALCULATE(SUM(Test11[Percent]),ALL(Test11[Percent]))

Best Regards,

Angelia

7 REPLIES 7

Greg_Deckler

Super User

Re: Calculate Percentage

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-15-2017
04:49 AM

In the Modeling tab, you can set a column to %. In your case, you may have to divide by 100.

Proud to be a Datanaut!

v-huizhn-msft

Super Contributor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-15-2017
11:12 PM

Hi @ravsha85,

You want to calculte the percentage of each value verse total value? For example, 10/(10+20+10+20+15+5+10+5+5), right? If it it, please create a calculated column using the following formula, and see the result shown in the following screenshot.

Percentage = Test11[Percent]/CALCULATE(SUM(Test11[Percent]),ALL(Test11[Percent]))

Best Regards,

Angelia

ravsha85

Member

Re: Calculate Percentage

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-15-2017
11:27 PM

Thanks Angelia, I have one more requirement though where I have to add (1+2+3+4+5)=15 and I have to dispay it as 15%

I tried to append "%" symbol in the end, but it dosent sums it after that (considering it as a string).

Thanks,

Ravi

Phil_Seamark

Super User

Re: Calculate Percentage

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-15-2017
11:32 PM

You should be able to just add an & operator to achieve this.

Measure = CALCULATE( SUM('Table1'[Column1]) )&"%"

ravsha85

Member

Re: Calculate Percentage

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-16-2017
01:32 AM

Thanks a lot, it works

v-huizhn-msft

Super Contributor

Re: Calculate Percentage

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-16-2017
01:52 AM

Hi @ravsha85,

Please mark the corresponding reply as answer, which will help more people find solution.

Best Regards,

Angelia

frugData

Occasional Visitor

Re: Calculate Percentage

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-05-2019
04:08 PM

Can you help me to reduce the decimal, my operation is 89.12457831484 %, only I want to have 2 decimal.

thanks!!