I have a sales table, with multiple items in every receipt. I want to filter with a slicer the receipts that have a specific item (product), but get the whole basket for these receipts and not only the specific item.
Tried the following measure as a filter on the specific visual, but doesn’t seem to work:
Filtered receipt ID = IF(MAX(Sales[Receipt ID]) IN CALCULATETABLE( VALUES(Sales[Receipt ID]),FILTER( SALES, Sales[Product ID] = SELECTEDVALUE(Products[Product ID]))) ,1,0)
Each receipt has multiple items (Sales ID) and each Sales ID corresponds to Product ID. Slicer is on Product ID
Thanks in advance for helping out if possible!