Attempting to calculate values in dataset where one of the parameters resides in a separate table

[PBINewbie12]

Hello PBI Experts!   Newbie here with a question:

I have a dataset that looks something like the following:

Requests for Assistance
Agent	Customer	Date
Dave	ABC	2/4/2021
Suzy	DEF	2/5/2021
Dave	DEF	2/6/2021
Joe	ABC	2/7/2021
Bill	GHI	2/8/2021
Suzy	ABC	2/9/2021
Tom	DEF	2/10/2021
Frank	ABC	2/11/2021
Jolene	GHI	2/12/2021
Maggie	ABC	2/13/2021
Suzy	ABC	2/14/2021
Dave	DEF	2/15/2021
Kathy	DEF	2/16/2021

I want to be able to calculate the number of times that customer ABC has requested assistance, and the agent that answered the question is one of our specialized agents as determined by the table below

Specialized Agents

Agent

Suzy

Frank

In this example, the answer would be 3.

Many thanks for the help!

[tamerj1]

Hi @PBINewbie12 
You can use 

Requests from Speciallized Agents = 
CALCULATE ( 
    COUNTROWS ( Requests ),
    Requests[Agent] IN VALUES ( Agents[Specialized Agents] )
)

[Nathaniel_C · Accepted solution]

Hi @PBINewbie12 ,

Try this.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Client ABC calls handdled by Specialized Agent = 

CALCULATE(COUNTROWS(Requests),FILTER(Requests,Requests[Customer]="ABC" && Requests[Agent] IN Values(S_Agent[Agent])))

[Nathaniel_C]