Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Creating Average from different table

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. 

nicksonteh_5-1654247556452.png

 

nicksonteh_4-1654246788896.png

Result expecting is 

nicksonteh_6-1654247642253.png

 

 

 

 

1 ACCEPTED SOLUTION

@Anonymous 

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

View solution in original post

8 REPLIES 8
tamerj1
Super User
Super User

@Anonymous 
Any relationship between tables?

Anonymous
Not applicable

@tamerj1 , 

hi, yes there is relationship between table

Anonymous
Not applicable

yes

@Anonymous 

Average =
AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Amount] )
Anonymous
Not applicable

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

DimaMD
Solution Sage
Solution Sage

Hi @Anonymous  Use the same measure I gave you earlier


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com
Anonymous
Not applicable

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_0-1654249353291.png

 

Anonymous
Not applicable

Hi, @DimaMD , 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.