How to sum data from SharePoint onto a report

[samirfarid]

Hi,

I currently retrieve some data from a SharePoint list which is stored in a DAX table as follows:

Id	Question 1	Question 2	Question 3	Comments
1	Yes	Yes	No	Lorem Ipsum
2	Yes	No	Yes	Lorem Ipsum dolor sit amet
3	(Blank)	No	No

On my Dashboard, I'm want to be able to show a Table / Matrix that shows the amount of Yes, No and blank answered questions. Something like this for example:

	Yes	No	Empty
Question 1	2	0	1
Question 2	1	2	0
Question 3	1	2	0

I read somewhere that this could be achieved using unpivoting in Power Query, but as my list contains about 15 questions and a lot of records, i was wondering whether unpivoting wasnt too much trouble performance wise, or if there is a simpeler way to achieve this.

Thanks for the help.

[v-chuncz-msft · Accepted solution]

@samirfarid ,

As far as I know, there is no more elegant way.