Creating Average from different table

[nicksonteh]

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]

@nicksonteh 
Any relationship between tables?

[nicksonteh]

@tamerj1 , 

hi, yes there is relationship between table

[nicksonteh]

yes

[tamerj1 · Accepted solution]

@nicksonteh 

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

[nicksonteh]

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

[DimaMD]

Hi @nicksonteh  Use the same measure I gave you earlier

[nicksonteh]

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

[nicksonteh]

Hi, @DimaMD , 

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