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.
Since you are new user, I would suggest a simple solution of putting filter on these measures in filter pane on Power BI Desktop. Put both filter conditions as below:
Self Answered initial=1
Self Answered final=1
Or you can create a third measure as below:
MeasureFIlterCustomer= IF(Self Answered initial=1 AND Self Answered final = 1, 1, 0)
Now put above measure in filter pane.
Let me know if you need any help. Mark this reply as solution if it answers your question.
Thank Megha166 for your response.
I created a measure
Hi @Megha166 ,
Thank you for your response. I have added two screenshot below.
In the first table, #self answered is the count of people who filled the initial survey.
In the second table, #self answered is the count of people who filled the final survey.
I will like to see only the people that filled both the initial and final survey. This will help me to see the unique average score for the respondents. Currently, it is biased towards the final phase because we have more respondents in the intial phase
Which DAX function can I use to solve this problem?
Thank you.
I see IDs are not duplicated. I need to understand your data in detail why IDs are getting duplicated. Can you attach the data in excel file here?
Countrows(filter(table,[selffinalnswer]=1))
On phone cant type well.
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 |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |