Forum Discussion
SACooper
Helper II
2 years agoFilter 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...
- 2 years ago
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! 🤠
SACooper
Helper II
2 years agothis is brilliant thank you