question

namnami avatar image
namnami asked

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?
ssascountdistinct
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.