Forum Discussion
Helper IVPower Bi slicer with AND condition
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
3 Replies
- amitchandak
Super User
Ethanhunt123 , what is the logic behind this need. when will system return an answer ?
Something like
if(distinctcount(Table[ Unique ID])>1,0,1)
Ethanhunt123I 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,.
v-xicaiCommunity Support
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.
