Power Bi slicer with AND condition

[Ethanhunt123]

I have two tables Table1, Table 2

Table1 contains Name,  Transaction, Date, Unique ID for Each Row

Table 2 contains data from Table1  and an additional column "Test Bucket" 

Table1 

ABC		1000		1
ABC		200		2
DEF&*		300		3
ASD		100		4

Table2

ABC		1		Bucket above 1000
ABC		2		Bucket bwteen200 and 300
DEF&*		3		Bucket bwteen200 and 300
DEF&*		3		Bucket name contains symbols

I made a slicer from the standard bucket. Slicer shows me value  Bucket bwteen200 and 300, Bucket name contains symbols, Bucket above 1000

I have a table visual created from table1, If I select Bucket between 200 and Bucket name contains symbols, from slicer table visual will give me 2 rows ABC and DEF&* details ( basically OR condition )

But what I need to do is a condition of AND in slicer so my output would be 0 rows 

[v-xicai]

Hi @Ethanhunt123 ,

>>But what I need to do is a condition of AND in slicer so my output would be 0 rows 

According to your logic, when you select the option "Bucket bwteen200 and 300" and "Bucket name contains symbols" in the slicer, the result will be 1, right?

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis?  Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Ethanhunt123 , what is the logic behind this need. when will system return an answer ?

Something like

if(distinctcount(Table[ Unique ID])>1,0,1)

[Ethanhunt123]

I want to detect fraud entries. 

The slicer is multi-select. I need details of the person whose name contains symbols and the amount is between 200 and 300 etc. So selection in slicer would work with AND condition,.