Sum in Matrix visual with filters from multiple tables

[molinamelody]

I will try to put my question out again as there were some issues with posting when I updated it.

I am trying to sum data in a Matrix with filters from multiple tables and am unable to determine the correct measures to use. 

What I am looking is result similar to the below:

I am unable to share the pbix, below is a view of the four separate tables of data I import into Power BI:

The data structure and measures I have tried so far:

1) Count ECountry = Calculate(DistinctCOUNT(Sheet1[ECountry]),KEEPFILTERS(Sheet1))

2) Epic Size = Calculate(Sum('Sheet1 (4)'[ESize]), KEEPFILTERS(Sheet1),('Sheet1 (4)'))

3) Epic Size Alloc = Divide([Epic Size],(SUMX(Sheet1,Sheet1[Count ECountry])))

Any help with calculations or guidance on data structure is much appreciated!

Melody

[molinamelody]

I am unable to share the pbix, below is a view of the four separate tables of data I import into Power BI:

The data structure and measures I have tried so far:

1) Count ECountry = Calculate(DistinctCOUNT(Sheet1[ECountry]),KEEPFILTERS(Sheet1))

2) Epic Size = Calculate(Sum('Sheet1 (4)'[ESize]), KEEPFILTERS(Sheet1),('Sheet1 (4)'))

3) Epic Size Alloc = Divide([Epic Size],(SUMX(Sheet1,Sheet1[Count ECountry])))

Any help with calculations or guidance on data structure is much appreciated!

Melody