Creating Average from different table

[Anonymous]

Hi everyone, hope you doing well. 

May I know how can i calculate average value from a different table ? below are the example. 

In table 1, i would like to calculate the average amount from table 2 based on the supplier ID. 

Result expecting is 

[tamerj1]

@Anonymous 
Any relationship between tables?

[Anonymous]

@tamerj1 , 

hi, yes there is relationship between table

[Anonymous]

yes

[tamerj1 · Accepted solution]

@Anonymous 

Average =
AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Amount] )

[Anonymous]

Hi !!!! thank you so much !!!! thanks for the answer !

[DimaMD]

Hi @Anonymous  Use the same measure I gave you earlier

[Anonymous]

Hi @DimaMD , would also like to clarify that. I wanted to create a new column in the table 1 that store the average value from table 2

[Anonymous]

Hi, @DimaMD , 

Thanks for replying, i have tried but not sure why it could not generate my expected result.