Trying to create Calculated Column with values from another table.

Hi, I am trying to create Calculated Column with values from another table.

(This is a very simplified version of the tables, and it is probably too large to append, table 1 has more fields, but those are the relevant ones)

The column needs to be in Table 1.

Table 1

Employee ID

Employee Name

Table 2

Order Number

Order ID

Order Date

Order Amount

Employee ID

Customer ID

I want to add to table 1 a unique count of customers that each employee has made an order for. I want it to be a calculated column rather than measure so I can easily work with it later.

Example:

Employee ID   Employee Name    Customer Count

1212                Jon                         5

2455                Ron                        1

9559                Bon                        3

Although if I could make it a measure, and create these measures with it, then I would be open to using a measure instead.

With this I want to make:

Employee's servicing 2+ customers

% of Employee's servicing 2+ customers

So far I have made a measure Employee Customer Count = Distinctcountnoblank('Table2'[Customer ID]), and was able to pull it into a matrix as the value, with Table 1 Employee ID as the row and get an accurate customer count.