Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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! 🤠
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |