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
ccianci
Frequent Visitor

average value ignoring filters

I need to get the average resolution time (for service desk tickets) for global staff.  I already got a working measure to calculate this average based on the employee name slicer.  I need a 2nd measuer that gets the same value but for all staff, ignoring that slicer but keeping the filter from the "opened_at" slicer (which factors in when the tickets were opened).

 

I'm not sure where to include "ALLEXCEPT" in this formula below.

 

I hope that makes sense and I didnt confuse you 🙂

 

Avg Global Resolution Time = 
( CALCULATE(
    AVERAGE(incident[Resolution Time in Days]),
    FILTER(
       incident,incident[assigned_to] IN VALUES('SD Engineers'[Engineer])))
) + 0

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @ccianci 

please try

Avg Global Resolution Time All Staff =
CALCULATE ( [Avg Global Resolution Time], ALL ( 'Table'[Staff] ) )

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @ccianci 

please try

Avg Global Resolution Time All Staff =
CALCULATE ( [Avg Global Resolution Time], ALL ( 'Table'[Staff] ) )

rautaniket0077
Resolver I
Resolver I

more info (such as sample data, expected output) needed.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.