Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Just got you, kindly add another measure:

    Measure 2 = CALCULATE(COUNTROWS(FILTER(VALUES(AnswerFeatures[UserID]),[Measure]="1")))

     Put it into the card.

     

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

The simplest way to achieve this is:

  1. Create a Slicer on your report and move SURVEYID to it.
  2. 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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,

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      Hi Anonymous ,

       

      Can you kindly put some screesnhots of the visual you tried and what is wrong and what is expected?

       

      Thanks,

      Pragati

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Pragati11 

         

        When I select SurveyId="qwerty12" it shows to me 4 UserID:

        And If I select SurveyID="dasdas23", I see 2 user:

        As you can see, When I select both "dasdas23" and "qwerty12",  UserID must be show onlt "abc123" because it is submit both "dasdas23" and "qwerty12". But now I select "dasdas23" and "qwerty12" it shows to me:

         

         

        Slicer always works as a "OR" filter, I need "AND" filter