Forum Discussion

SACooper's avatar
SACooper
Icon for Helper II rankHelper II
2 years ago
Solved

Filter a summarized table, but still show breakdown.

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

Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

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

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion
    2 years ago

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