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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.