Forum Discussion
Working out %
Hi I have created a measure which calculates the % of people who responded to a question in a survey as below: = COUNT(Sheet[Respondent ID]) / CALCULATE (COUNT(Sheet[Respondent ID]), ALL(Q7[Q...
Anonymous,
Create the following measures in your Sheet table.Strongly Agree&Agree = CALCULATE(COUNT(Sheet[Respondent ID]),FILTER(Sheet,Sheet[Q7 Response ]<>"" && (Sheet[Q7 Response ]="Strongly Agree" || Sheet[Q7 Response ]="Agree")))
alleffectiveresponse = CALCULATE (COUNT(Sheet[Respondent ID]),FILTER(Sheet,Sheet[Q7 Response ]<>""),ALL(Q7[Q7 Group]))-CALCULATE (COUNT(Sheet[Respondent ID]),FILTER(Sheet,Sheet[Q7 Response ]="I don’t use this"),ALL(Q7[Q7 Group]))
Measure = [Strongly Agree&Agree]/[alleffectiveresponse]
Regards,
Lydia
Thank you
Anonymous,
Could you please accept my reply as answer? That way, other community members would easily find the answer when they get same issues.
Regards,
Lydia