Data Model

[mandar5118]

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.

[mandar5118]

https://www.loom.com/share/c4422d6c17b74c1ab9419789e43d4319

I have explained the issue on the above video link. This should help 🙂

[Ashish_Mathur]

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

[tamerj1]

@mandar5118 

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. 

[Dinesh_Suranga]

@mandar5118 
Hi,

Could you please share some sample data?

Thank you