Matrix - Using multiple 'values' fields for a single column

[Incipient]

Is there any way to use multiple 'values' fields for a single 'column' field and not have powerbi duplicate each 'value' field under each 'column' name?

I need to have different ways of aggregating and different units for each 'values' field.

Essentially "Table" has all of the values, and table "A" as only the 'a' col rows, table "B" only the 'b' col rows.

Here "Table B Values" have no data for the "a" column, but powerbi still shows an entirely blank column.

I do realise this isn't super clear, but tried to make it MVC.

[amitchandak]

@Incipient ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Are these tables joined with each other ? If not create proper joins

[Incipient]

This is an exmple doc: https://1drv.ms/u/s!AojLy6AugI3vqPYBqQIstJZ84mLpBw?e=IjzDai

I can't manually hide columns as I have about 30-40, and they are dynamically selected based on what values are in the "column" field in the matrix.

If powerbi cannot find a "AveAge" value in the "Population" column, I want it to not show that column.

Current look (includes empty columns):

Desired output (achieved by collapsing the unwanted columns in this example):