Forum Discussion
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[bodycomp1])
row 2 column 2 AVERAGE(calctable[cardio1])
and so on....
3 Replies
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)
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.
Avg Dist = IF ( NOT ( ISBLANK ( 'Table'[Distance] ) ), CALCULATE ( AVERAGE ( 'Table'[Distance] ), ALLSELECTED ( 'Table' ) ) )
