Trying to create Calculated Column with values from another table.

Spudder112 , Try like

calculate( Distinctcountnoblank('Table2'[Customer ID]),filter(Table2, Table1[Employee ID] = Table2[Employee ID]) )

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

Thank you! I had tried this formula as well. I realize now that it actually is working. 

My issue seems to actually stem from trying to trend the data by dates. With this new created column, what is the best way to show this ordered by dates. The Date field is in Table2 as well as a date table.

End result would be the ability to create the below. With that current formula, the customer count just repeats across dates.

Employee ID   Employee Name    1/1/2023    1/2/2023    1/3/2023

1212                Jon                         5                  2                3

2455                Ron                        1                  5                2

9559                Bon                        3                  7                1

I want to be able to say 66% of our employees serviced 2+ customers on 1/3/2023.