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 =  DIVI...
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.

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.