In this table example, the DISTINCTCOUNT of TransactionID = 3 (basket count), however TransactionID 72461 has 3 x Unit sales (of different products) making it a multi-unit basket. I am looking to iterate through the FACT table to only count multi-unit basket and not quite sure how to approach it