Forum Discussion
Ethanhunt123
Helper IV
6 years agoPower 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 ...
amitchandak
Super User
6 years agoEthanhunt123 , what is the logic behind this need. when will system return an answer ?
Something like
if(distinctcount(Table[ Unique ID])>1,0,1)
Ethanhunt123
Helper IV
6 years agoI 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,.