Forum Discussion
Solved
Combining Filter with AND
Hello Community, I have two Tables: Customers and Contracts. In the contracts table I have one column "type". I then have a matrix where I display per client which typ's of contracts he has. ...
Ah, you desire the mythical AND Slicer. Luckily, it exists. This one is of my own invention and is in my book actually:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort-AND-Slicer/m-p/391883#M130
With an explanation because the way it works is not obvious at all. But, I think it is the most concise AND slicer out there if not intuitive in how it operates.
If you need on of the value
Table[ e contract of type] in {"A", "B","E"}
I am not how both can be true , but this example of and
Table[ e contract of type]= "A" && Table[ e contract of type]= "B" && Table[ e contract of type]= "E"
Example of OR
Table[ e contract of type]= "A" || Table[ e contract of type]= "B" || Table[ e contract of type]= "E"