Forum Discussion

DionTN's avatar
DionTN
Icon for Helper II rankHelper II
4 years ago

Add average to selected column and row

I want to add a calculated value to the selected row in the selected column.   I have this table: Now i want to add averages in this table. So in row 1 column 2 i need AVERAGE(calctable[bod...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi DionTN ,

 

Have you a sanitised version of the raw data you can share?

 

Did I help you today? Please accept my solution and hit the Kudos button.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  DionTN ,

    As checked your shared csv file, there are mulitple fields there. Which value field do you want to get the average value? Could you please give some special examples to explain your final expected result? Thank you.

     

    If you want to get the average values, you can refer the following links to get it.

    Show average per rows

    Avg Dist =
IF (
    NOT ( ISBLANK ( 'Table'[Distance] ) ),
    CALCULATE ( AVERAGE ( 'Table'[Distance] ), ALLSELECTED ( 'Table' ) )
)