Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi All,
I have a survey data with 5 Question
1.) Whom yu are living with : girlfriend, wife
2.) If the person healthy : yes, no, partially
3.) Is the person working : Yes, No
4.) Are you happy with the person : Yes, No, Cant Say
5.) If the person owns a house : yes, no
I want to analyse one answer impacts the rest of the answers. For eg. how many of perople living with wife who has house and are happy. The requirement is to analyse these answers along each other.
The data collected is this format below. Please suggest what would be the best way to analyse the data in such fashion.
| UserId | Question | Answer |
| 1 | Whom yu are living with | Wife |
| 1 | If the person healthy | Yes |
| 1 | Is the person working | No |
| 1 | Are you happy with the person | Yes |
| 1 | If the person owns a house | No |
| 2 | Whom yu are living with | Girlfriend |
| 2 | If the person healthy | Partial |
| 2 | Is the person working | Yes |
| 2 | Are you happy with the person | Yes |
| 2 | If the person owns a house | No |
| 3 | Whom yu are living with | Wife |
| 3 | If the person healthy | Yes |
| 3 | Is the person working | yes |
| 3 | Are you happy with the person | No |
| 3 | If the person owns a house | Yes |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |