measure using filter off two different data tables

[Anonymous]

i need help getting a correct count using two different measure fields. hopefully i can explain. one table has an offense date. an employee can generate multiple offense date rows. that table also as an employee ibm number. the other table is from a schedule. the emplyee has a shift start date and is on a shedule. the employee can be moved to multiple scedules. it also has employee ibm number. i need to be able to count the activity of each employee by the schedule shift start date and the schedule that he is on.Sorry i cant figure out how to paste the pbix file

[moizsherwani]

ok probably will be easier to help you if you put in some dummy data and also the expected result, a screenshot from an Excel sheet where you do this is probably easiest

[moizsherwani]

@Anonymous Can you share a view of the data model?

[Anonymous]

[Anonymous]

work data

ibm

number

offense date

schedule

ibm

schedule

shift start date