- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum with multiple filters for different columns in the same table
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-28-2023 08:30 AM | |||
11-23-2023 11:42 AM | |||
05-26-2023 07:05 AM | |||
10-19-2023 09:56 AM | |||
03-03-2024 02:45 AM |
User | Count |
---|---|
23 | |
12 | |
10 | |
10 | |
8 |
User | Count |
---|---|
16 | |
15 | |
15 | |
12 | |
10 |