Matrix visual/ different meauere at the cells of matrix

[Do57792]

Hello Experts,

I have the following origin data:

Houses	Region	Date	Column 1	Column 2
1	W	01 Jan	1	4
2	W	05 Jan	2	5
3	N	02 Feb	7	6
4	W	02 Feb	7	12

Now I want to display a matrix like an excel table, with different measures/filters for the measures at each cell. The problem is, that I can't ( or I don't know) how to change the layout of my origin data table. If I change this, like pivot, I will get duplikates at the "House" columns, but this column is also connected to another table. If I would do this I will get a n:m connection. Right now the 1 : * is fine. The duplicate at the result ("Spot 1") is not an error; I would like to get a result like I have shown at the example results.

Or is there a visual wher I can insert a different measure at each cell?

Result, what I would like to have at my report:


Region=W

	Jan	Feb
Spot 1	= sum(Column1), Region = W, Date =Jan (result =3)	= sum(Column1), Region = W, Date =Feb (result =7)
Spot 2	= sum (Column 2),Region W , Date =Jan  (result =9)	= sum (Column 2), Region = W, Date =Feb (result =12)
Spot 1	= sum(Column1), Region = W,Date =Jan (result =3)	= sum(Column1), Region = W,Date =Feb (result =7)

Many thanks for your help!

[Do57792]

Many thanks!

[mickey64 · Accepted solution]

Step 0: I use your data.

Step 1: I unpivot this data table on Power Query Editor.

Step 2: I click 'Close & Apply'.

Step 3: I make a table and add a relationship below.

    Houses Table = SUMMARIZE('DATA','DATA'[Houses])

Step 4: I make a matrix.