topic Re: Build a new table with the count of one value in DAX Commands and Tips

Build a new table with the count of one value

Anonymous — Fri, 09 Apr 2021 16:32:16 GMT

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

Re: Build a new table with the count of one value

daxer-almighty — Sun, 11 Apr 2021 23:16:47 GMT

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-p/1626726

Re: Build a new table with the count of one value

RichardTam — Tue, 13 Apr 2021 03:33:03 GMT

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