Forum Discussion
Using Slicer as AND Filter
Hi Everyone,
we have some data set as below.
ResponseFeatues
| ResponseID | UserID | SurveyId | RecordedDate |
| 987xyz | abc123 | qwerty12 | 01.01.2020 |
| 765fsd | def456 | qwerty12 | 01.01.2020 |
| 456wqw | abc123 | dasdas23 | 02.01.2020 |
AnswerFeatures
| ResponseID | UserID | SurveyId | QuestionID | AnswerChoice |
| 987xyz | abc123 | qwerty12 | Q1 | A |
| 987xyz | abc123 | qwerty12 | Q2 | A |
| 765fsd | def456 | qwerty12 | Q2 | C |
| 765fsd | def456 | qwerty12 | Q3 | D |
| 456wqw | abc123 | dasdas23 | Q1 | B |
| 456wqw | abc123 | dasdas23 | Q2 | C |
| 456wqw | abc123 | dasdas23 | Q3 | A |
Firstly, I want to see which users submit one more survey when I select this survey on slicer. For example, When I select "qwerty12" and "dasdas23" surveys on the slicer, it show to me UserId "abc123". It must not be only 2 selection, It can be 2 more.
And so I want to see how many users submit selected surveys.
Hi Anonymous
Just got you, kindly add another measure:
Measure 2 = CALCULATE(COUNTROWS(FILTER(VALUES(AnswerFeatures[UserID]),[Measure]="1")))Put it into the card.
16 Replies
Hi Anonymous ,
The simplest way to achieve this is:
- Create a Slicer on your report and move SURVEYID to it.
- Create a table visual and move USERID column to it.
Now try selecting differebt values from your slicer, it should give you required result.
Thanks,
Pragati
Hi Pragati11,
I'm sorry but it is not working. Because If I select one more SurveyID in the slicer, It shows to me users which submit one or more this surveys. But I need users which submit all selected Survey. I need intersection users for this Surveys.
Best,
Hi Anonymous ,
Can you kindly put some screesnhots of the visual you tried and what is wrong and what is expected?
Thanks,
Pragati
Hi Anonymous
Kindly let me know if you'd like to get below results:
Pbix attached.
Hi Anonymous
I just removed the enhanced option, please also make sure you're using the latest desktop version, kindly check this one 🙂
