Forum Discussion
Continued ContributorCreate matric with data from same column
Continued ContributorCan't be done, since I need to filter out the question:
It fails because I only need the answer for that particalur question on the row, and when I need answers for the column it says - forget it...
Am I doing something wrong?
Solution SageI have added a question dimension table also. It seems to have removed errors. I have created a PBIX to look through https://drive.google.com/file/d/1ECGfUUTD5iAgKQJckQb4f4VI34PdAoJ9/view?usp=sharing
- Bokazoit
Okey, using that aproach is the same in a way as craating a model for surveys with mulitple questions and multi-answers. That produces one dimension for every question with answers inside.
I already have that, but building a datamodel with several surveys inside and by that a huge amount of dimQuestion's is not very userfriendly in an organisation.
Therefor I was hoping for a solution where I could cross two questions from the same column with answers on its own row and column.
But that seems impossible i am afriad 😞