dax - Count Unique Occurrences PowerPivot -

i new powerpivot , dax formulas. assume trying basic , has been answered somewhere, don't know search on find it.

i trying determine percent of sales people had sale in given quarters. have 2 tables, 1 lists sales people , 1 list sales quarter. example

employee id 123 456 789  sales id - emp id - amount 135645 ---- 123 ----- $50 876531 ---- 123 ----- $127 258546 ---- 123 ----- $37 516589 ---- 789 ----- $128 998513 ---- 789 ----- $79 

as result, pivot table this:

emp id - % w/ sales 123 -------- 100% 456 -------- 0% 789 -------- 100% total ------- 66% 

if can point me post has been addressed or let me know best way address appreciate it. thank you.

here's simple way of doing (assuming table names emps , sales):

=if (distinctcount ( sales[emp id] ) = blank (),         0,         distinctcount ( sales[emp id] )      )     / countrows ( emps ) 

the if() required ensure people haven't made sale appear in pivot. actual formula doing dividing number of sales rows number of employee rows.

jacob