Forum Discussion

ccianci's avatar
ccianci
Frequent Visitor
3 years ago
Solved

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

 

  • Hi ccianci 

    please try

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

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi ccianci 

    please try

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