Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to sum total value in visual

Hi all,

 

May know the best way to sum the total value in visual so that I can get the percentage under total visual as per below.

 

Yield in M2 (%) = Total GR (M2) / Total GI (M2)

Regards,

Nuha

General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    hi Anonymous 

    try using the below measure

     

    Yield in M2 (%) = Sum(Table[Total GR (M2)]) / Sum(Table[Total GI (M2)])

     

    If this post helps , accept it as a solution

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    hi Anonymous 

    try using the below measure

     

    Yield in M2 (%) = Sum(Table[Total GR (M2)]) / Sum(Table[Total GI (M2)])

     

    If this post helps , accept it as a solution

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks! I create a "new measure" and do division.