Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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. 

 

Result expecting is 

 

 

 

 

  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

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

8 Replies

  • DimaMD's avatar
    DimaMD
    Solution Sage
    4 years ago

    Hi Anonymous  Use the same measure I gave you earlier

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi, DimaMD , 

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      yes

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Anonymous 

        Average =
AVERAGEX ( RELATEDTABLE ( Table1 ), Table1[Amount] )
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      tamerj1 , 

      hi, yes there is relationship between table