Efficiency calculation

[Anonymous]

Task Name	Task Start	Task End	Student	Student Start Date	Student End Date
Task 1	1/1/2017	Null	Student 1	1/1/2017	4/1/2017
Task 1	1/1/2017	Null	Student 2	4/2/2017	4/5/2017
Task 1	1/1/2017	Null	Student 1	4/6/2017	12/1/2017
Task 1	1/1/2017	Null	Student 3	12/2/2017	12/31/2017
Task 2	1/5/2017	Null	Student 3	1/1/2017	12/31/2017
Task 2	1/6/2017	Null	Student 1	7/1/2017	12/31/2017
Task 3	1/7/2017	Null	Student 2	3/1/2017	7/1/2017

I have a sample dataset like this. In such case, I need to find what will be the load% or efficiency% of each student. How can I determine this using DAX? I tried to calculate days worked by taken the difference of days and distinct tasks. But i end up creating 4-5 measures. Any suggestions?

Also, how do I filter this by Year and Month that efficiency comes until that date? Example - If i choose from Jan 2017 to Aug 2017, it must display efficiency until Aug 2017.

[Ashish_Mathur]

Hi,

How do you calculate Load% or Efficiency %?  Show the expected result.

[Anonymous]

It's basically calculating average number of tasks done by a student when he is working. This shall also get filtered by any date that I choose in the slicer.

[afzalphatan]

Can you please show the expeceted result in a pic with intended formula

[Anonymous]

Could you please show the output with the formula?

[Greg_Deckler]

OK, so COUNT of Tasks is you numerator it sounds like, what is your denominator? Since this is a %. Is it the COUNT of all tasks (regardless of student), the number of days the student is working?