cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ravsha85
Helper IV
Helper IV

Calculate Percentage

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

1 ACCEPTED SOLUTION
v-huizhn-msft
Microsoft
Microsoft

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]))


Capture51.PNG


Best Regards,
Angelia


View solution in original post

7 REPLIES 7
frugData
New Member

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

 

 

thanks!!

v-huizhn-msft
Microsoft
Microsoft

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]))


Capture51.PNG


Best Regards,
Angelia


View solution in original post

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

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

 

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

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Thanks a lot, it works 🙂

Hi @ravsha85,

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

Best Regards,
Angelia

Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors