Count number of in severalcolumns

[wongmeta]

Hi guys!

This is my first time to do customer satisfaction survey analysis via Power BI.  I have stuggles how to count the number in several columns.  Example: survey score 1-5 and I would like to count how many customer given "1" from Q.1 - Q5 and percentage as well. In excel very simple just drag and count but I can't do so in Power BI.  It's allow just only one column.  please enlighten me

Thanks in advance!

[Tahreem24]

@wongmeta  You every column you need to create seperate Count formula.

Count Q_1 = COUNT(Table[Q.1 Column])

Count Q_2 = COUNT(Table[Q.2 Column])

. ..... and so on.

[wongmeta · Accepted solution]

Thank you for your advise!

I want to the count number of people who given score 1 and 2 and 3 ..... from question 1-5 to do a chart like this.

[amitchandak]

@wongmeta , If Columns 1.1, 1.2 ,1.3 are question numbers, I would advise them to unpivot. And you can have a question dimension if needed. That should make it easy

https://radacad.com/pivot-and-unpivot-with-power-bi

[wongmeta]

I've 25 questions in survey. 

I did unpivoted but don't know how to count the number of people who given score 1, 2, 3 in several questions.

I want to create chart like below example. this is to show number of people who given score 1-5 in question number 1-5 (combine into 1 chart).

Thanks