Visual Suggestion

Hi kpl_999 

I would write two DAX formulas for both as one will serve for Country and the other for category.

It will be better if you provide your table structure with sample data of all the columns used in the screenshot. this helps you get the exact solution rather than multiple replies asking for different information about data.

So, I am not sure how you are geting all the columns in the report. Considering they are all in rows for each country and categorywise and is calculated using a measure named measure_x and average is required for display.

_country_level = Calculate(AVERAGEX(table,table[measure_x]), ALLEXCEPT(table,table[country]))

_category_level = Calculate(AVERAGEX(table,table[measure_y]), ALLEXCEPT(table,table[category]))

If required, you may have to create a calculated field for each column and use SUMX, MAXX, AVERAGEX as required.

By using the above calculation you will not have to worry about new country or category.