I am doing basket analysis. I have following tables (sales, product and filter product (which is same as product table). Sales table has active relationship with Product and inactive relationship with Filter Product using Product Group field.
I can count my basket using following expression - Basket = DISTINCTCOUNT(‘Sales’[TransactionID]). However when calcuating “Basket with Both Products” I want to filter out transactions which has only 1 transaction. Please help how can i achieve that ?