Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.