Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show total average in each row

Hi 

I need to show the total average of 147% in a new column repeating the value for each row. ( the outcome I need is in red below)

 

This is the calculation for arrears=
arrears = 

DIVIDE( [Open balance], [Total Charges])
 
what's the best way to achieve this?
 
Thanks!!

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Try the following measures

    Measure = CALCULATE(AVERAGE('Table'[Arrears]),ALL('Table'))
    Measure 2 = IF(HASONEVALUE('Table'[City]),SUM('Table'[Arrears]),[Measure])

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Anonymous 

    Please try the below.

     

    New measure =
    CALCULATE ( [arrears], ALL ( [your city column name] ) )

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      Thanks for getting back to me.

       

      I tried this first and It didn't work I think because the arrears is taking two different tables in it.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Try the following measures

    Measure = CALCULATE(AVERAGE('Table'[Arrears]),ALL('Table'))
    Measure 2 = IF(HASONEVALUE('Table'[City]),SUM('Table'[Arrears]),[Measure])

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.