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

[Bfaws]

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

[harshnathani · Accepted solution]

Hi @Bfaws ,

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

Regards,

HN

[harshnathani · Accepted solution]

Hi @Bfaws ,

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

Regards,

HN

[Bfaws]

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

[harshnathani · Accepted solution]

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

[Bfaws]

Hi Harsh Nathani,

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

Thanks,

Brendan