Average of sums - logic of SUMMARIZE

[Anonymous]

Hello Everyone, I calculated the following measures: 

Yearly Average = AVERAGEX(SUMMARIZE('Fact table','Fact table'[Year]) ,[Production])

Then I calculated the same table as in the formula above: 

Table = SUMMARIZE('Fact table','Fact table'[Year],"Sum",[Production])

and then the following measures: 

Average X 2 = AVERAGEX('Table','Table'[Sum])

Average of sum = Average('Table'[Sum])

The issue is that the first measure works very well in the model. I can filter by many other dimensions and the value is getting updated, but the two remaining measures are not. Filters from dimension tables don't affect them. 

Can you explain to me the logic behind SUMMARIZE or AVERAGEX? Why does it work when I created a virtual table and doesn't work when I created a real, static table from the same syntax? 

[amitchandak · Accepted solution]

@Anonymous . Once you create a calculated table it can not take the slicer filters. You need to join it again with slicer/dimension tables (This is a static table build when you refresh data)