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] )

     

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity 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!!!