I have a survey with 3 questions. 2 of which are "Yes" and "No" questions, while one is a multiple choice (can have more than one selection) question where the answer only counts as "Yes" if all four choices are selected. Create Power BI DAX formulas on how to calculate the % of "Yes" answers per question out of all distinct users.
Dividing by distinct users will not work as this survey is 1 out of 3 surveys in my table and each survey will have different users who answered them.
Sample Table:
| User | Survey No. | Question No. | Answer |
| 1 | 1 | 1 | Yes |
| 1 | 1 | 2 | Yes |
| 1 | 1 | 3 | Option 1 |
| 1 | 1 | 3 | Option 2 |
| 1 | 1 | 3 | Option 3 |
| 1 | 1 | 3 | Option 4 |
| 2 | 1 | 1 | Yes |
| 2 | 1 | 2 | No |
| 2 | 1 | 3 | Option 1 |
| 3 | 2 | 1 | Yes |
| 3 | 2 | 2 | No |
Expected % Yes:
Survey 1, Question 1: 100%
Survey 1, Question 2: 50%
Survey 1, Question 3: 50%
Survey 2, Question 1: 100%
Survey 2, Question 2: 0%
