cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kelly_Zhu Member
Member

How to calculate Total Percent

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How to calculate Total Percent

@Kelly_Zhu

 

This MEASURE should get you desired result

 

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

 

2 REPLIES 2
Highlighted
Super User
Super User

Re: How to calculate Total Percent

@Kelly_Zhu

 

This MEASURE should get you desired result

 

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

 

Kelly_Zhu Member
Member

Re: How to calculate Total Percent

Thanks for your help!!!

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.

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