Forum Discussion
Data Model
I have a requirement where I need to show analysis accross multiple questions for a given survey. The analysis has to be such that all questions need to be connected with each other and everything should essentially work together.
The problem is when I select one question, then the other questions are filtered which is obvious. But I need to see the data for everything.
Its a very tricky problem to explain, but I tried my best.
4 Replies
Question ID has to be in a Dim. Table connected to the main fact table with an inactive relationship that can be activated only when needed.
https://www.loom.com/share/c4422d6c17b74c1ab9419789e43d4319
I have explained the issue on the above video link. This should help 🙂
Hi,
I am not sure how much i can help but i can try. Share the download link of your PBI file and keep only those tables there which are necesary for solving the question - remove the other tables. Also, please show the expected result in a simple table format
