Add average to selected column and row

[DionTN]

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

row 2 column 2 AVERAGE(calctable[cardio1])

and so on....

[davehus]

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.

[DionTN]

https://drive.google.com/file/d/1MBudlc3W-DeyjOsN5TUtxMIvyWmIrgRw/view?usp=sharing

@davehus Usually i have a SQL connection, this is a export file. It needs to be a calculated field cause of changing filters. (CompanyID and appointment ID)

[Anonymous]

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

average by group

DAX Calculations: Total Of Average Results

Best Regards