Reply
Member
Posts: 71
Registered: ‎07-17-2017
Accepted Solution

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


Accepted Solutions
Highlighted
Super User
Posts: 2,820
Registered: ‎09-27-2017

Re: How to calculate Total Percent

@Kelly_Zhu

 

This MEASURE should get you desired result

 

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

 

View solution in original post


All Replies
Highlighted
Super User
Posts: 2,820
Registered: ‎09-27-2017

Re: How to calculate Total Percent

@Kelly_Zhu

 

This MEASURE should get you desired result

 

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

 

Member
Posts: 71
Registered: ‎07-17-2017

Re: How to calculate Total Percent

Thanks for your help!!!