Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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!       Regards, Kelly
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    This MEASURE should get you desired result

     

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

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

This MEASURE should get you desired result

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for your help!!!