Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter for a Field with Multiple Values per User

I'm working on a dataset with survey responses and building a number of filters based on the user responses. Respondent data, answer data, answer options data, and questions data are all in their own...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ，

     

    First  create a slicer table as below:

     

     

    slicer table = VALUES('Table'[QuestionId])

     

     

    Then create a measure as below:

     

     

    Measure = 
var _tab=CALCULATETABLE(VALUES('Table'[Answer Text]),FILTER(ALL('Table'),'Table'[QuestionId]=SELECTEDVALUE('slicer table'[QuestionId])))
Return
IF(MAX('Table'[Answer Text]) in _tab,MAX('Table'[Answer Text]),BLANK())

     

     

    And you will see:

     

     

     

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , I am not very clear with question.

Count of question for which all users have given same answer(free text is not removed)

 

a new measure 

countx(filter(summarize(answers, 'answers'[QuestionId] , calculate(countdistinct(answers[AnswerText]))), [_1]=1),[QuestionId])