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[Offe...
  • Daniel29195's avatar
    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! 🤠