Distinct count of values which are displayed in two columns in SSAS
Hi, How is it possible to get distinct count of two columns in fact table, meaning how many different appearances are in both columns. Please note I DO NOT mean distinct count on the concatenated fields. I’ll demonstrate with example: Fact table- deals with CustomerID and SupplierID and deals data. I need distinct count of companies which are either customer/ supplier in the fact table. (making a concatenated field and distinct count on that would not give what I need). Ex: fact : Deal1, Customer X, Supplier Y … Deal2, Customer X, Supplier Z … Distinct count of companies in the above should be 3. How can this be done?