Solved: Re: How to calculate Total Percent

Kelly_Zhu · ‎01-14-2018

Hi Everyone,

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

Regards,

Kelly

Zubair_Muhammad · ‎01-15-2018

This MEASURE should get you desired result

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

Regards
Zubair

Please try my custom visuals

Zubair_Muhammad · ‎01-15-2018

This MEASURE should get you desired result

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

Regards
Zubair

Please try my custom visuals

Kelly_Zhu · ‎01-15-2018

Thanks for your help!!!

How to calculate Total Percent