I have been trying to solve this problem, but it is proving to be quite tricky. I have attached pbix file. Here is what I want and here is my data model.
Using the below example transactions, If I select “Dishwasher” from my “Product” and “Filter Product” table, I want to see 1 transaction to qualify as my basket (xxx123), even though they are the same product. However I want to exclude transaction sss109, ppp666.
pbix file.Basket Analysis.pbix (83.9 KB)