Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
As far as I know, there is no more elegant way.
As far as I know, there is no more elegant way.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |