distinct count based on 2 columns with value in either

[Anonymous]

I have 2 calcuated measures counting headcount from 2 systems phone and email

if an agent answered the phone I count the number of unique users per day, these agents also answere email or don't

if an agent replys to an email I count the number of unique users per day, these agaents also answer phones or don't

I need a 3rd measure to count how many total unique agents I have 

so in this example my daily total head count should be 5

agent	phone	email
Bill
Sue	1	1
Jill		1
Joe	1
Jack		1
Rob	1	1

currently I have

a call table

which has agent id, and call

an email table

which has agent id, and email

and an agent table to join the two

[AlexisOlson · Accepted solution]

I imagine you want something similar to this:

HeadCount =
CALCULATE (
    DISTINCTCOUNT ( Table1[agent] ),
    FILTER ( Table1, NOT ( ISBLANK ( [phone] ) && ISBLANK ( [email] ) ) )
)

[Anonymous]

@AlexisOlson 

I think this will work, so this says if phone and email are blank don't count it?

[AlexisOlson]

Yep. It doesn't count agents with both of those blank (I'm assuming that's why the count is 5 instead of 6 including Bill).