How can I pivot columns with DAX

Question

Hi There,&nbsp;I have a table like this:&nbsp;IDSurveyIDResponseIDQuestionTextAnswerTexta1SV_123R_A1question1Ab2SV_123R_A1question2Bc3SV_124R_B1question3Cd5SV_125R_C1question4D&nbsp;&nbsp;I have a lot of question text and users can answer this question a lof of time so I have a lot of responseID.&nbsp;&nbsp;I need this a measurement as working pivot table. Because I have to create a report like this:&nbsp;Pie charts should change according to the filters selected in the segment section.&nbsp;Sample Cases,&nbsp;- The distribution of people who participated in Survey1, answered Answer65 to Question11 in any surveys, and answered Answer37 to Question12 in any surveys,&nbsp;- The distribution of people who participated in Survey2 and Survey3 both (common users), answered Answer65 to Question11 in any surveys, and answered answer15 to Question13in any surveys

amitchandak · Answer

Anonymous , the expected output is nor clear can you elaborate

anonymous · Answer

Hi&nbsp;amitchandak&nbsp;&nbsp;You can reach my sample report in there:https://drive.google.com/file/d/1yX0TOh6fvUi3Ko9_oxZBb-IxLzw4RtZZ/view?usp=sharing&nbsp;Best,

anonymous · Answer

Hi There,&nbsp;Do you have any solution about this?&nbsp;Best,

anonymous · Answer

Hi,&nbsp;Anonymous&nbsp;&nbsp;I don't understand your requirements very well, like&nbsp;“Answer X to Question X in any surveys”Could&nbsp;you please explain more about how you expect the output to look like? make it more specific ,thanks!&nbsp;&nbsp;Hope I can help!&nbsp;Best Regards,Caitlyn Yan

Forum Discussion

How can I pivot columns with DAX

4 Replies

Related content

Power BI Pivot Columns ?

Pivot issue

Pivot / Unpivot?

Power Query Pivoting columns issue

How to pivot Multiple Columns

ID	SurveyID	ResponseID	QuestionText	AnswerText
a1	SV_123	R_A1	question1	A
b2	SV_123	R_A1	question2	B
c3	SV_124	R_B1	question3	C
d5	SV_125	R_C1	question4	D