topic Re: Help with DAX Filter Function (or other option if better) in DAX Commands and Tips

Help with DAX Filter Function (or other option if better)

Bfaws — Fri, 05 Jun 2020 13:05:41 GMT

Hi,

I was hoping someone could help. I have a list of absences from employees - this list contains employee number, absence type and amount of hours. The end result is that i calculate the average amount of days off per person. I have this done nicely for all absence types, and can add a slicer that filters by a specific absence type. I would really like a stand alone table which shows the absence type "Sick (Unplanned)" without using a filter.

What I would really like is a measure that calculates the average days off person by a single or group of absence types so I can use these as stand alone visuals. I have tried the filter finction but am struggling.

Please see the attached .pbix for more information

Access file here

Any help would be much appreciated.

Thanks,

Brendan

Re: Help with DAX Filter Function (or other option if better)

Anonymous — Fri, 05 Jun 2020 13:44:18 GMT

Hi Bfaws ,

# Absent Day Sick Unplanned = CALCULATE(Absenteeism[# Absent Days],FILTER(Absence,Absence[Abs. code(T)] = "Sick (Unplanned)"))

Regards,

Re: Help with DAX Filter Function (or other option if better)

Bfaws — Fri, 05 Jun 2020 13:59:47 GMT

Hi HN,

Thats brilliant - thank you very much.

What if I needed to add another couple of absence types to form a group - "Sick (Planned)", and "Part Time Medical Grounds" - is there a way to ammend the existing measure?

Thanks again,

Brendan

Re: Help with DAX Filter Function (or other option if better)

Anonymous — Fri, 05 Jun 2020 14:07:23 GMT

Hi Bfaws ,

You can use this measure.

# Absent Day Group = CALCULATE(Absenteeism[# Absent Days],FILTER(Absence,Absence[Abs. code(T)] IN { "Sick (Planned)","Part Time Medical Grounds" } ))

Regards,

Harsh Nathani

Re: Help with DAX Filter Function (or other option if better)

Bfaws — Fri, 05 Jun 2020 14:17:47 GMT

Hi Harsh Nathani,

Thanks you so much - this is really helpful and has worked exactly as expected.

Thanks,

Brendan