Looks like what I need. Can you post the file you published so I can see how you did it?
(I figured out why the date was missing in my version. My drop down location has over 70 entries. When the drop down affects filtering of the data, it also filters the calendar numbers. I created a base table with a baseline for each location and it works. But that requires 25,000 entries per calendar year on the spreadsheet.)
Here's another possibility, don't use the Location Id from the secondary source as a filter. Instead, create a calculated field in the primary source based on the parameter and use it as part of the blending.
You'll notice here, that I've removed the filter and kept the measure as it was, but all the counts are correct based on the parameter selection:
I accomplished this by creating a calculated field in the primary source that just contained the parameter value:
And then include it on the blend in the secondary source:
The reason this works, is that often, when you use a filter from a field in the secondary source -- the filter is applied after the blend. So, if there wasn't a Location Id record for that date, the date record gets removed. However, if we don't use the filter and instead use the blend, then we get all fields from the primary source (every date) and any corresponding fields from the secondary. The Location Id part of the blend limits it to be data only for the desired location.
I've attached a workbook to demonstrate how it would work. Hope that helps!
August.twbx 52.5 KB