Can't Get KPI Visual to work with Multiple Tables

So I had mine set up exactly like that, but it doesnt work when a date range is picked. So if I had my date selected as 2 days, I would want the sums of each value compared. Even in the PBIX you shared, it only shows the most recent date's value if both dates are selected. Ideally I actually dont want an external filter selection, I want the filter baked into the visual because I'm going to have a KPI for each employee. So in your example, I'd want 2 KPI visuals, one for John and one for Alice, with a date slicer, and if I picked both dates April 1 and 2, for Alice it should show 11/13 (5/6 + 6/7) and Johns would show 15/17 (10/11 + 5/6).

You can see here that for March 21st and April 3rd (single dates), it works and its accurate.

But when I select a range between the two dates, it only shows most recent data (from April 3rd) in the KPI card, it should show the values in the two "Card" visuals to the left: 

Heres my data:

I want the KPI to show the total value for the date range.