What type a model supports this kind of questinonare/survey report?

[Bokazoit]

There is from my knowledge two ways to build a datamodel from a survey:

1. One Fact and then two dimensions Question and Answer

2. One Fact and each question has its own dimension to be able to set together 2 questions in the same chart as an example

Now, from time to time I get the question, if it is possible to show all the answers in a chart even if the answers is zero. Neither of the above let me do that, since using a date dimension will remove any answer outside the choosen period.

What possible ways or datamodels could I use or is it almost impossible?

[rajendraongole1]

Hi @Bokazoit - While traditional fact-dimension models may not directly support the display of zero answers, with the strategies outlined above, you can design a data model that allows for comprehensive reporting of all possible answers. Adjusting your data preparation, utilizing comprehensive dimensions, and crafting thoughtful measures will help you achieve the desired outcomes in your reports.

You can create DAX measures that return a default value (like zero) when there are no responses for specific combinations of questions and answers. Use the coalese() function or similar logic to ensure that zeros are shown when there are no records.

Hope the above details helps.

[Bokazoit]

Sorry I am well aware of the model building, but You give me absolutly no answers to my question. If it was that easy I would not ask but post the solution myself.