Goals for dataset when no records reported

I have a scenario where I have my base dataset with all records that I need to report on. There is a quantity column that I'm summing to see how many quanities were reported on per location by day/week. I have another table that has goals per location. I am joining the goals table to the base dataset based on location ID. 

The visual to compare quanities to the sum of goals (and then filter by location) by day is working however when there is no quantities reported in my base dataset for a certain location, the goal is removed. I need the goal to stay static instead of adjusting but because the location is not available for that time period, the goal is removed.

How can I solve this? I want the goal to stay the same instead of adjusting based on whether or not the quantity is available for the location.