Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SACooper
Helper II
Helper II

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

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

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

View solution in original post

2 REPLIES 2
SACooper
Helper II
Helper II

 this is brilliant thank you

Daniel29195
Super User
Super User

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.