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: 
Reply
Kelly_Zhu
Kelly_Zhu Member
Member

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

Report Inappropriate Content
Message 1 of 3
Labels:
0
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Zubair_Muhammad
Super User
Super User

Re: How to calculate Total Percent

‎01-15-2018 02:46 AM

@Kelly_Zhu

 

This MEASURE should get you desired result

 

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

 

Report Inappropriate Content
Message 2 of 3
Reply
2 REPLIES 2
Highlighted
Zubair_Muhammad
Super User
Super User

Re: How to calculate Total Percent

‎01-15-2018 02:46 AM

@Kelly_Zhu

 

This MEASURE should get you desired result

 

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

 

Report Inappropriate Content
Message 2 of 3
Reply
Kelly_Zhu
Kelly_Zhu Member
Member

Re: How to calculate Total Percent

‎01-15-2018 09:34 PM

Thanks for your help!!!

Report Inappropriate Content
Message 3 of 3
0
Reply

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

View All
Users Online
Currently online: 6 members 3,198 guests
Recent signins:
Please welcome our newest community members:
View All