Build a new table with the count of one value

[Anonymous]

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. 

Age	P1	P2	P3	… PN
15	YES	YES	YES	YES
16	NO	YES	YES	YES
18	YES	NO	NO	YES
20	YES	NO	NO	YES
22	YES	NO	NO	YES
7	NO	NO	YES	YES
9	NO	NO	NO	NO

Need build this!!!

	YES	NO
Q4	4	3
Q1	2	5
Q2	3	4
Q3	6	1

[RichardTam]

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]

You have not received any replies... Please read this: https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...