How can I join 2 Table Viz need to join.

[CoCoAndo]

Hi All,

I have the following 2 tables Visulistations but would like to join them so I am showing the avg values in the top table above the total. 

The Month Year is coming from a calculated column in my 'date table' then other columns are meausres I have created.

Any help would be much appricated.

[Greg_Deckler · Accepted solution]

@CoCoAndo Fairly certain that you are going to need a disconnected table for your first column then with a singe custom measure. The basic technique is along the lines of this: https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hiera...