I’m a bit worried about changing too many things at the same time. Let’s work for the moment within the context of your current data model, get the cumulative totals right so that you can provide the information needed ASAP, and then when the time pressure is off a bit, we can step back and rework that.
No need at the moment for the harvesting/disconnected slicer approach – I think we can make do without having to go down that road. In terms of joining the two tables, the way I would do it would be to get the structures as lined up as possible between the two tables (remove any unnecessary columns, rename columns as consistently as possible across the two tables), then for each one add a column called Status or Source (just a way to differentiate between the two once they’re combined), and in that column fill with “Isolation” for the first table, “Hospitalization” for the second table, then append (not merge - we want to create new rows, not new columns) the two tables into a new combined table.
I’ll dig in on the cumulative total work this afternoon and get back to you later today.
P.S. Thanks for the information about the kibbutz. I googled it, since it’s always interesting to know more about the background of the people, places and issues behind these data models and DAX measures that we work on.