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.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-diye-msft ,

 

I've got this error, when I've tried to open this pbix.

 

 

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

I just removed the enhanced option, please also make sure you're using the latest desktop version, kindly check this one 🙂

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      6 years ago

      Hi Anonymous 

       

      Let me explain the details:

      Please add the measure:

      Measure = var t = CALCULATETABLE(VALUES(AnswerFeatures[SurveyID]),ALL(AnswerFeatures[SurveyID]))
var a = ALLSELECTED(AnswerFeatures[SurveyID])
Return
IF (
        ISBLANK ( COUNTROWS ( EXCEPT ( a, t ) ) ),
        "Yes")

      It will filter the "AND" results from the selection of slicer.

      There 2 tables connected by response ID. note that you can't use the SurveyId in ResponseFeature to filter the userID in AnswerFeature.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi v-diye-msft 

         

        It seems good but I want to try to see count of userID which submit selected all surveys in Card Visualization, it is not working. Because I can not filter Measure = Yes