Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Cleaned Data = SUMMARIZE( tblData_QueuePerformanceByPeriod, tblData_QueuePerformanceByPeriod[MidnightStartDate - Date], tblConfig_Queue[Name], "Total Calls", SUM(tblData_QueuePerformanceByPeriod[Offered]) )
This DAX provides me a 3 column table esentially DATE, TOTAL CALLS and QUEUE, I'd like to filter out DATEs where the sum of TOTAL CALLS is less than a defined value for example 100, but then still show the remaining values broken down by queue. Not had much luck getting that working.
TIA
Solved! Go to Solution.
filter(
addcolumns(
SUMMARIZE (
tblData_QueuePerformanceByPeriod,
tblData_QueuePerformanceByPeriod[MidnightStartDate - Date],
tblConfig_Queue[Name]
),
"Total Calls", calculate(SUM ( tblData_QueuePerformanceByPeriod[Offered] ))
),
[Total Calls] < 100
)
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
this is brilliant thank you
filter(
addcolumns(
SUMMARIZE (
tblData_QueuePerformanceByPeriod,
tblData_QueuePerformanceByPeriod[MidnightStartDate - Date],
tblConfig_Queue[Name]
),
"Total Calls", calculate(SUM ( tblData_QueuePerformanceByPeriod[Offered] ))
),
[Total Calls] < 100
)
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
88 | |
87 | |
35 | |
35 |
User | Count |
---|---|
153 | |
99 | |
85 | |
63 | |
54 |