topic Re: Creating Average from different table in DAX Commands and Tips

Creating Average from different table

Anonymous — Fri, 03 Jun 2022 09:14:45 GMT

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

DimaMD — Fri, 03 Jun 2022 09:24:05 GMT

Hi Anonymous Use the same measure I gave you earlier

Anonymous — Fri, 03 Jun 2022 09:38:04 GMT

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

Anonymous — Fri, 03 Jun 2022 09:42:51 GMT

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

tamerj1 — Fri, 03 Jun 2022 09:50:14 GMT

Anonymous
Any relationship between tables?

Anonymous — Fri, 03 Jun 2022 09:51:47 GMT

yes

Anonymous — Fri, 03 Jun 2022 09:52:21 GMT

hi, yes there is relationship between table

tamerj1 — Fri, 03 Jun 2022 09:52:30 GMT

Anonymous

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

Anonymous — Fri, 03 Jun 2022 09:58:23 GMT

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