Average of different columns in different tables

[vkats]

Hello there,

i have 2 tables..each one has got one column that i took the average.

I want to have the average of these 2 columns but i cant.

Can you help me on this?

[v-yueyunzh-msft · Accepted solution]

Hi , @vkats 

According to your description, you want to "Average of different columns in different tables".

This is my test data:

I created two columns to simulate the average column in your two tables.

Then we can create a measure :

Measure = var _t1 = SELECTCOLUMNS('Table1' , "Col1",[Column1])
var _t2= SELECTCOLUMNS('Table2',"Col1",[Column1])
 var _t3= UNION(_t1,_t2)
 return
 AVERAGEX(_t3,[Col1])

Then we can get the average of these two columns:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Ahmedx]

Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.