Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to find average from 2 different table

hello Guys, Hope you are doing well.  May I know how can I calculate the average score from 2 different table that have one to many relationship ? kindly refer to the example below.  Table in yello...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    It is for creating a new column.

     

     

    Avg expected result CC = 
DIVIDE (
    SUMX ( RELATEDTABLE ( Score1 ), Score1[Score] )
        + SUMX ( RELATEDTABLE ( Score2 ), Score2[Score] ),
    COUNTROWS ( RELATEDTABLE ( Score1 ) ) + COUNTROWS ( RELATEDTABLE ( Score2 ) )
)
MahyarTF's avatar
MahyarTF
Icon for Memorable Member rankMemorable Member
4 years ago

Hi,

In Power Query, you could Append two tables as new or in one of them,

Then use the created table and bring the "Supplier name" and average of Score in your visual :

Appreciate for Kudos