Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Kelly_Zhu
Helper III
Helper III

How to calculate Total Percent

‎01-14-2018 10:14 PM

Hi Everyone,

 

I would like to create a table like below. Could you provide me some suggetion about this? Thank you in advance!

 

Percent.PNG   

Regards,

Kelly

Labels:
Message 1 of 3
1,070 Views
0
1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

‎01-15-2018 02:46 AM

@Kelly_Zhu

 

This MEASURE should get you desired result

 

Percent =
SUM ( Table1[Column B] ) / SUM ( Table1[Column C] )

 


Regards
Zubair

Please try my custom visuals

View solution in original post

Message 2 of 3
1,120 Views
2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

‎01-15-2018 02:46 AM

@Kelly_Zhu

 

This MEASURE should get you desired result

 

Percent =
SUM ( Table1[Column B] ) / SUM ( Table1[Column C] )

 


Regards
Zubair

Please try my custom visuals
Message 2 of 3
1,121 Views
Kelly_Zhu
Helper III
Helper III
In response to Zubair_Muhammad

‎01-15-2018 09:34 PM

Thanks for your help!!!

Message 3 of 3
1,046 Views
0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

View All