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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Build a new table with the count of one value

I have this table as result of a quiz & need build a new table with only a selected columns using the headers and the count of the answer yes & no. The headers must be in the rows and the yes & no in the columns. 

 

AgeP1P2P3… PN
15YESYESYESYES
16NOYESYESYES
18YESNONOYES
20YESNONOYES
22YESNONOYES
7NONOYESYES
9NONONONO

 

Need build this!!!

 

 YESNO
Q443
Q125
Q234
Q361
2 REPLIES 2
RichardTam
Helper I
Helper I

Under Edit Query

1. Create unique ID

2. Select all column except unique ID

3. Transform > Any Column > Unpivot Column

4. Home > Close > Close & Apply

 

Click Matrix under Visualizations

Rows: Attribute

Columns: Value
Values: Count of unique ID

daxer-almighty
Solution Sage
Solution Sage

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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