Hi i have an attendance table that i want to count each employees sickness days (S) and unauthorized absence days (A) from
I have grouped all the id numbers and the with the attendance type and then created the 2 measures
Days Absent = CALCULATE ( COUNTROWS ( '2019 Attendance Data' ), '2019 Attendance Data'[Absence Type] = "S" ) Separate Absences = CALCULATE ( DISTINCTCOUNT ( '2019 Attendance Data'[Block Index] ), '2019 Attendance Data'[Absence Type] = "S" )
This works fine when i just want the results of sickness only (S) however i want to also return the unauthorized absence days (A) how can i modify the above to find both criteria? its not the same as excel and just use &.