I have a simple fact "sales lines" table with [customer],[reseller],[item], [family item ], [qty] ecc.
I need a measure [Number of customer] which count (distinct count) the number of customers
that buy items in at least 3 different [family item]
Can someone help me :)
I would use SQL to populate a table that contains all of the customers for a certain period that meets the criteria. The create a distinct count measure group based on that table.