Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@Anonymous
Average =
AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Amount] )
@Anonymous
Any relationship between tables?
yes
@Anonymous
Average =
AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Amount] )
Hi !!!! thank you so much !!!! thanks for the answer !
Hi @Anonymous Use the same measure I gave you earlier
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
Hi, @DimaMD ,
Thanks for replying, i have tried but not sure why it could not generate my expected result.
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |