Append in Matrix (or not Grouping rows)

[Anonymous]

Hello everyone!

I have built a fact table A that its rows are combination of every person and question made to that person and its answer (Yes/no). It looks like that:

And I have one dimension table with all questions listed and 2 columns that gives 2 classifications of that question. Something like that:

So, at my report, I want to build a matrix that shows something like the following:

But I can't seem to achieve it, the only result that i get is building two matrix, one for type_1 rows and other for type_2:

When i try to append the rows by inserting both fields in the row section, i just get the combination of them both.

Is that a way to achieve it? 

Thanks in advance,

Gabriel Monteiro

[Anonymous]

Thanks @amitchandak , that's what i was looking for, but i was afraid of using Many to Many relationship. Just for curiosity, Is that another way to solve this?

[amitchandak · Accepted solution]

@Anonymous , You can unpivot the table 2 (Type_1, Type_2) , that will create a many to many case, but it should work

https://radacad.com/pivot-and-unpivot-with-power-bi