Count numbers of days an employee worked

[eliasayy]

hello I want to find the total days my employee worked, what is the formula for power bi given i have 2 tables , i want to create the column in the employee table , and the other table has list of daily attendance of each employee.

so this is my attendance table:

id- name- absent

1 -ari -True

1 -ari -Present

1 -ari -Present

2 -james -True

2 -james -True

2 -james -Present

i want in the employee table to add the days worked column to have:

id -name -days worked

1 -ari -2

2 -james -1

[Avantika-Thakur · Accepted solution]

Hi @eliasayy ,

Assuming that there's a relationship between the Attendance Table and Employee Table based on the ID column,

you can try creating the below measure -

Measure = calculate(count(Attendance),ALLEXCEPT(Table,Table'Name'),filter(Table,Attendance = "Present"))

Hope this helps.

Please accept the solution if this answers your query

Thanks!

Avantika