Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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:

 

firatseker_0-1611039600190.png

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

4 REPLIES 4
Anonymous
Not applicable

Hi There,

 

Do you have any solution about this?

 

Best,

Anonymous
Not applicable

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
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors