Counting records only if they are also in another table

[df123445]

I have 2 tables:

"planned visits" and "visited"

PLANNED VISITS:

ID	Quarter	SALES REP
1	Q1	John
2	Q1	John
3	Q1	John
1	Q2	John
4	Q1	Rob
6	Q1	Rob

VISITED:

ID	Quarter	SALES REP
1	Q1	John
2	Q1	John
4	Q1	Rob

I have 2 measures that count how many clients each sales rep has per quarter:

CALCULATE(DISTINCTCOUNT('PLANNED VISITS'[ID]),GROUPBY('PLANNED VISITS', 'PLANNED VISITS'[Quarter], 'PLANNED VISITS'[SALES REP] ))

and 

CALCULATE(DISTINCTCOUNT('VISITED'[ID]),GROUPBY('VISITED', 'VISITED'[Quarter], 'VISITED'[SALES REP] ))

Unfortunately Sales reps do unplanned visits sometimes , so I may have the situations where the measure for "VISITED" is higher than the "PLANNED" measure. For example, the VISITED table may look like this:

ID	Quarter	SALES REP
1	Q1	John
2	Q1	John
4	Q1	Rob
99999	Q1	John

How can I make sure the second measure ONLY selects IDs that are in the PLANNED VISITS table? 

Hoping my explation is clear, TIA 

[daircom · Accepted solution]

Hi @df123445 ,

Looking at the documentation of the CALCULATE function, you can see that you can add multiple filters (your GROUPBY is the first and only filter you apply). 

CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])

This means, you can simply add a comma and add another filter to only look at ID's available in your other table. Something like:

CALCULATE(
    DISTINCTCOUNT('VISITED'[ID]),
    GROUPBY('VISITED', 'VISITED'[Quarter], 'VISITED'[SALES REP] ),
    'VISITED'[ID] IN VALUES('PLANNED'[ID])
)

now you added anothter filter.