How to filter multiple tables with 1 filter

I have multiple data files, available via SQL.

All data files have at least 1 similarity with each other, namely ''Company ID''.

The various files have various streams of information, which are all measured on unique dates, now I want to create 1 filter (called: date filter), I want this filter to display from the various data files the desired information (all available information between the dates in the filter)!

What am I doing wrong?

Overview current model:

Overview current raport with problem in: table 2 and 3:

To support the formula in the date filter:

 What is the reason for this problem and how do I solve it?