Calculating distinct values in two separate columns

[Eternalbliss]

Hello,
I'm fairly new to PowerPivot and I have a problem, most probably with a simple solution which I haven't been able to find myself.
I have two separate tables with columns of phone numbers. To be more precise - one table lists answered calls, another - unanswered. I need to know how many unique callers there were within given period of time (both answered and unanswered, not separately).
I presume that I start with using DISTINCT function on each of the columns separately, which generates list of unique values in each, but I don't know how to merge these values and do DISTINCTCOUNT on them. I hope I'm clear with my problem, thanks in advance.

 

[Jacob Barnett]

DISTINCTCOUNT is definitely what you need but it only works on a single column if you are looking for unique numbers across both types of calls.

To solve this you will need to create a single table with all entries - for my money this would be a more intuitive data structure and there are a number of ways to do it!

What kind of format is your data in? E.g. Spreadsheet, Database etc.