Measure with a filter - IF

[corange]

Hi everyone, 

I am after some help with one of my project. 

I have a company with three departments - Univeristy, Primary School and Secondary School and the company is located in two states. i report on different metrics and one of them is the average daily jobs per employee and per state. In the report, I offer user the posibility to see metrics by department using a slicer visual as a filter. For me to obtain the average daily job number, I simply drop Units in the field and select "average". 

Where I am stuck is that if an employee is working for University and does 1 to 3 jobs a day, it should be removed from the average. The results should always incorporate this rule not matter if I select the slicer visual to check on all Department or a specific Department: employee working for University doing less than or equal to 3 jobs a day, are not to be included in the average daily job number. For those same employees, we report on their earnings and average working hours daily and it is to be included even if it was only 1 job. Therefore I can't go to the source and filter all <=3 jobs a day as i still need some of the data against that employee. 

I have highlighted below what should be excluded from my average job number for the University Employee: 

To obtain the following results: 

Here a sample of my dataset: https://1drv.ms/u/s!AiS7XVNuQsBCc4RVVjGVoKHwa4Y?e=6AOLFP 

I really hope someone can assist as I dont know at all how I can solve this. 

Thank you. 

[amitchandak]

@corange , Try measures like that

countX(filter(summarize(Table,Table[employee],"_1", sum(Table[unit])),[_1]<=3),[employee])

sumX(filter(summarize(Table,Table[employee],"_1", sum(Table[unit])),[_1]<=3),[_1])