Forum Discussion

mstefancik's avatar
mstefancik
Advocate IV
10 years ago
Solved

Distinctcount based on two columns

Hello,   I have got 2 tables with different columns, but wto columns are same, date and customerID. I would like to do distinctcount to count all customerIDs from these two tables.   As sho...
  • sdjensen's avatar
    sdjensen
    10 years ago

    Hi mstefancik,

     

    You could try this:

     

    First calculate a new table having the values of CustomerID from Table1 and Table2

    Table = UNION (VALUES( 'Table1'[CustomerID] ), VALUES (Table2[CustomerID] ) )

     

    And then create a measure that counts the distinct values in the new table

    Distinct Customers = DISTINCTCOUNT('Table'[CustomerID])

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi mstefancik,

 

In addition, you can also use "Append Queries" feature in Query Editor to append Table2 to Table1. The new table looks like below:

 

Then create a measure to return the count of distinct values:

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu