Sum with multiple filters for different columns in the same table

[TJCappy]

Ihave two tables,
1 is employeedirectory and has thr following columns:
employeename
EmployeeID
department
Title


2 is XFX Genesys Agent queue and has the following columns:
Interaction type,
Queuename,
Accepted,
Agent name,
Handle time,
AgentID.


the two tables are connected by columns EmployeeID and AgentID
I need to create a measure that will give me the number of calls each agent has accepted "inbound" from each of the queues 

the  Accepted column is a number that represents the total number of calls accepted within the period of an hour.

I have tried the following but nothing seems to give me the result I need 


a)
Calls Accepted by Agent = CALCULATE( SUMX( FILTER( 'xFX Genesys Agent Queue', 'XFX Genesys Agent Queue'[Interaction type] = "Inbound" && 'XFX Genesys Agent Queue'[Accepted] > 0 ), 'XFX Genesys Agent Queue'[Accepted] ) )

b)
Calls Accepted by Agent = CALCULATE( COUNTROWS('XFX Genesys Agent Queue'), FILTER( X'FX Genesys Agent Queue', 'FX Genesys Agent Queue'[Interaction type] = "Inbound" && 'XFX Genesys Agent Queue'[Accepted] > 0 ) )

I have also tried various combinations of summarize and summarizecolumn 

All to no avail

can someone please help me out.  Thanks

[Anonymous · Accepted solution]

Hi, @TJCappy 

Based on your information, I created two sample tables:

Then create a new measure and try the following dax expression:

Calls Accepted by Agent = 
SUMX(
    FILTER(
        'XFX Genesys Agent Queue', 
        'XFX Genesys Agent Queue'[InteractionType] = "Inbound" && 
        'XFX Genesys Agent Queue'[Accepted] > 0
    ), 
    'XFX Genesys Agent Queue'[Accepted]
)

You can create another slicer and put the Queuename in it to filter the number of times different Queuenames are used.

Here is my preview:

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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