Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How can I pivot columns with DAX

Hi There,

 

I have a table like this:

 

IDSurveyIDResponseIDQuestionTextAnswerText
a1SV_123R_A1question1A
b2SV_123R_A1question2B
c3SV_124R_B1question3C
d5SV_125R_C1question4D

 

 

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

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , the expected output is nor clear can you elaborate

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi There,

     

    Do you have any solution about this?

     

    Best,

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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