Filter a summarized table, but still show breakdown.

[SACooper]

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

[SACooper]

 this is brilliant thank you

[Daniel29195 · Accepted solution]

@SACooper 

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! 🤠