Matrix table cannot aggregate the values, shows blank fields

1. My requirement is to use a Matrix Visual, to display 4 types of pillars (Cross-cutting, environmental, political, social) in columns and rows will have (commodity, country, weighting, and overall risk by country. 
2. After using the below measure, my output looks something like (the attached image)
3. Calculated Column used for "Average of Issue Score 2" this -
4.  "Average of Issue Score2" =

CALCULATE(AVERAGE('Distinct table'[Issue Score 2]), ALLEXCEPT('Distinct table', 'Distinct table'[Commodity], 'Distinct table'[Country], 'Distinct table'[% Weight], 'Distinct table'[Pillar]))

Current output that im getting:

But, what i want to showcase as an end result is the (below image) - DESIRED OUTPUT

this is the required or expected output

NOTE: 

First image - COLUMN "Average of Issue Score 2" and Second image - COLUMN "Overall Risk by Country". Both are same columns. (naming is different)

The above 2 columns - "Average of Issue Score 2" and "Overall Risk by Country", they are coming from a different table (a sub table from the main table populating the DISTINCT values).

Any help will be apreciated. 

Thank you 

D--