How can I pivot columns with DAX

[Anonymous]

Hi There,

I have a table like this:

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

I have a lot of question text and users can answer this question a lof of time so I have a lot of responseID. 

I need this a measurement as working pivot table. Because I have to create a report like this:

Pie charts should change according to the filters selected in the segment section.

Sample Cases,

- The distribution of people who participated in Survey1, answered Answer65 to Question11 in any surveys, and answered Answer37 to Question12 in any surveys,

- 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

[Anonymous]

Hi There,

Do you have any solution about this?

Best,

[v-xiaoyan-msft]

Hi, @Anonymous 

I don't understand your requirements very well, like “Answer X to Question X in any surveys”

Could you please explain more about how you expect the output to look like? make it more specific ,thanks!

Hope I can help!

Best Regards,

Caitlyn Yan

[amitchandak]

@Anonymous , the expected output is nor clear can you elaborate

[Anonymous]

Hi @amitchandak 

You can reach my sample report in there:

https://drive.google.com/file/d/1yX0TOh6fvUi3Ko9_oxZBb-IxLzw4RtZZ/view?usp=sharing

Best,