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.

     

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

Hi Anonymous 

 

You can filter the measure is not blank, or change the below as "1", then filter it =1 :

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-diye-msft 

 

I can not filter the card visulation by Measure. It doesnt let me to the change filter as you said.

 

 

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    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 

     

    Thank you. It seems good.

     

    Best,