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.
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.
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 |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |