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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors