Forum Discussion
Advocate IVData Preparation on Power BI Desktop
Solution SupplierI understand you have survey data, presented in rows (UserId, Question, Response) and you want to be able to answer questions like "how many customers answered A to question 1 and answered B to to question 2?"
Creating new columns is the way to go, if you want to use an un arbitrary number of filters.
Alternatively, Marco Russo and Alberto Ferrari have proposed a pattern that only allows the user to apply a predefined number of filters:
http://www.daxpatterns.com/survey/
This drawback comes with the advantage that no unpivoting is required, resulting in less memory being required (due to fewer columns being present in the data model).
See if it works for you.
Microsoft Employee- hjameelq
Well for me it worked perfectly, what I did is I splitted the data sets into separate sheets and it worked without any huge slowness, I thought it is not gonna work but apparently, it did :)
