Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
I am new to DAX and I have a table with losts of different surveys and peoples answers to the surveys.
1) I need to know if a customer has completed all of the questions (in this example 8 questions)
2) If all questions are answered mark the survey as complete.
3) count that as one completed survey.
4) If the survey has one question answered mark as part completed, and count as one servey (to count the servey I would just count (distinct) customerID)
Could anyone give me some guidance on how I would acheive this please?
Many thanks,
Sean.
Solved! Go to Solution.
The DAX will be much easier if you break your one big table down into a star schema (I can help you break it down if you need)
My next step was to add a calculated column to the Client Survey records to determine if an individual question had been answered.
Here's the DAX for that column:
Help when you know. Ask when you don't!
The DAX will be much easier if you break your one big table down into a star schema (I can help you break it down if you need)
My next step was to add a calculated column to the Client Survey records to determine if an individual question had been answered.
Here's the DAX for that column:
Help when you know. Ask when you don't!
Thank you for the asnwer, I will try and understand it in the morning.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
19 | |
17 | |
12 | |
9 | |
9 |