Sum with multiple filters for different columns in the same table

TJCappy — Thu, 09 May 2024 21:29:57 GMT

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

Re: Sum with multiple filters for different columns in the same table

Anonymous — Fri, 10 May 2024 07:25:01 GMT

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.

topic Sum with multiple filters for different columns in the same table in DAX Commands and Tips

Sum with multiple filters for different columns in the same table

Re: Sum with multiple filters for different columns in the same table