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 ,

 

First thing slicer doesn't work as an OR, it works as an AND when multiple values are selected.

Second thing, in your previous screesnhot for data tables, I don't see all the users that you have shown in your current screesnhot. 

Am I missing something or you shared data table screesnhots as an example for 2 users only?

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Pragati11 ,

 

Yes you can see my sample data table below:

 

ResponseIDUserIDSurveyIDRecordedDateLanguageDurationFinished
987xyzabc123qwerty121.01.2020EN100True
765fsddef456qwerty121.01.2020EN80True
456wqwabc123dasdas232.01.2020AR92True
849sdafds234qwerty122.01.2020AR76False
344kjdgfds23dasdas232.01.2020EN97True
873jhaddsa23ghst5622.01.2020EN75True
927hsgdada23ghst5623.01.2020EN94False
773dad54fsdqwerty123.01.2020EN73True

 

Actually, I need as this solution:

https://medium.com/seismic-data-science/changing-or-to-and-logic-for-power-bi-slicers-1a6b20aee5f5. But it is working very slowly. So I think that I must solve this problem different way.