Multiple average values across one column depending on another column

[Anonymous]

Hey guys, 

I want to calculate average values of column 2 depending on changing values in column 1. This average value should be written in a new column 3. The average value can be repeated in this new column 3. Values of column 1 are not predetermined so the code should depend on a change of values and not the defined values. 

column 1	column 2	column 3
160	0,402	0,4065
160	0,406	0,4065
160	0,408	0,4065
160	0,41	0,4065
140	0,28	0,2813
140	0,286	0,2813
140	0,278	0,2813

I would really appreciate your help! 

Regards 

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Column 3 = CALCULATE(AVERAGE('Table'[column 2]),ALLEXCEPT('Table','Table'[column 1]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[Anonymous]

Thanks!