View My Drafts
Using the measure below, I can calculate the availability without respect to employment and term dates and everything seems to display correctly in some different visual types. I need some mechanism for excluding dates prior to the hire date and after the termination date, in a way that calculates correctly both for an individual employee and for a group of employees that may have different start and term dates.
Capacity = COUNTROWS(CALCULATETABLE(Employee))*COUNTROWS(CALCULATETABLE(Date,Date[Control]="Open"))
I had thought that I could use DATESBETWEEN to produce another filter when calculating the date table, but I don't see a way to reference those values on the Employee table, just other measures I wrote on that table- and without being able to see the results in a visual, I can't assess if this would even work correctly when reviewing the capacity of multiple employees. Any input is greatly appreciated!