Forum Discussion
Using Slicer as AND Filter
Hi Anonymous
Just got you, kindly add another measure:
Measure 2 = CALCULATE(COUNTROWS(FILTER(VALUES(AnswerFeatures[UserID]),[Measure]="1")))Put it into the card.
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
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
Hi Pragati11 ,
Yes you can see my sample data table below:
ResponseID UserID SurveyID RecordedDate Language Duration Finished 987xyz abc123 qwerty12 1.01.2020 EN 100 True 765fsd def456 qwerty12 1.01.2020 EN 80 True 456wqw abc123 dasdas23 2.01.2020 AR 92 True 849sda fds234 qwerty12 2.01.2020 AR 76 False 344kjd gfds23 dasdas23 2.01.2020 EN 97 True 873jha ddsa23 ghst562 2.01.2020 EN 75 True 927hsg dada23 ghst562 3.01.2020 EN 94 False 773dad 54fsd qwerty12 3.01.2020 EN 73 True 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.