Calculation to show members with no value

[tarmogolf]

Currently I have an Location Roster table with fields LocationName and DistrictName. I then have an Employee Roster table with an AssignedLocationName and EmployeeName, connected to the Location Roster table. Finally, I have a table with employee scheduling data that shows what location they are working at, and how many minutes they are scheduled to work by day. The model is working properly, for instance when I group by week number I can see how many minutes each employee is scheduled to work at:

The issue I am having, though, is that in the above example there is actually a fourth employee, "Z", that is also assigned to this location, but has not had their schedule created. I would like to show "0" for each week where an employee is assigned to this location, but has no scheduling data available. Any thoughts? One "hack" that was suggested to me was simply doing something like this: 

Scheduled Minutes = SUM('Schedule & Time Clock'[Total Scheduled Shift Minutes])+0

but that ended up showing literally every employee in the company under every location.

[amitchandak · Accepted solution]

@tarmogolf , There is one more, but that will also show all data (Show Item with Not data)

You have force remove additional data , example

0 between range
Measure = var _1= SUM('Schedule & Time Clock'[Total Scheduled Shift Minutes])+0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

[tarmogolf]

The "Show items with no data" option worked perfectly when I choose the employee field. I had *no* idea that option existed, thank you for showing me something new!