Average of two columns from two different tables

[saud968]

I need an average of two columns from two different tables. I have created an average of a column name Score from Table CSAT and an average of a column name CSAT from Table MDA Sheet.

Average SAT CW = AVERAGE(CSAT[Score])

Average SAT CMS = AVERAGE('MDA Sheet'[CSAT])

I do not want to sum of average but the combined average of both columns or if we can get average by those two measures will work

@Jihwan_Kim @ChrisMendoza @amitchandak @AllisonKennedy @Greg_Deckler 

[amitchandak · Accepted solution]

@saud968 , few ways, based on what you need

Average SAT CW = (AVERAGE(CSAT[Score]) +  AVERAGE('MDA Sheet'[CSAT]))/2

or like

Averagex(Union(all(CSAT[Score]), all('MDA Sheet'[CSAT]) ), [Score])

[saud968]

@amitchandak THank you for the quick response - 

(AVERAGE(CSAT[Score]) +  AVERAGE('MDA Sheet'[CSAT]))/2 this one worked out