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!

v-kelly-msft's avatar
v-kelly-msft
Community Support
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!