I have seen examples of this where the product is within a single column, but how is this handled when the product is essentially their own column.
In the example that I have uploaded, I have a dimension called Product (row Pill) and what I am trying to do is a count of clients that have Linear + search
or Linear + DigA. When I add a condition where Product = Search and Product = Linear it fails as each row in the underlying database only mentions one product at time. If try and change to an Or statement i am massively over counting.
Ideally, you should pivot your data in this case. If you cannot pivot it, then you may be able to achieve what you want by using LODs. Unless you can share your data file, I cannot suggest an appropriate solution.