Discount count multiple tables

Hi @mrstillchicken,

Here’s the sample data I used according to your description:

Please check following steps as below and see if the result achieve your expectation:

1. Manage relationship between two tables:

2. Create measure:

    distinctcount = CALCULATE(DISTINCTCOUNT(Projects[customer]),FILTER(Assigment,Assigment[empid] = MAX(Assigment[empid])))

3. Result would be shown as below:

BTW, Pbix as attached. Hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.