average value ignoring filters

ccianci — Sat, 08 Apr 2023 16:22:11 GMT

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

Re: average value ignoring filters

rautaniket0077 — Sat, 08 Apr 2023 17:40:49 GMT

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

Re: average value ignoring filters

tamerj1 — Sat, 08 Apr 2023 18:38:04 GMT

Hi ccianci

please try

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

topic average value ignoring filters in DAX Commands and Tips

average value ignoring filters

Re: average value ignoring filters

Re: average value ignoring filters