Filter Date Table with conditions from other column in different table

[HeihoSilver]

Hi, 
I have a relationship of "Date Table" and "Table A". The connection of data is based on "Connect Live" so I can't do any data transformation other than to use DAX measure. 
Table A:  "ID", "Created Date", "Due Date" and "Location" columns.

Date Table: "Date" column

The relationship between the 2 table is based on 'Date Table[Date]' and "Table A[Created Date]'.

I would like to calculate the number of ID where Due Date < Today, 
Y = CALCULATE(COUNTA(Table A [ID]),  Table A [Due Date] < (TODAY()) )

. The calculation is to be applied in a histogram where X = Location and Y axis as mentioned.

From there I would like the user to be able to click on the bar and should filter the Table accordingly. 
However, I found that the table didn't filter accordingly. Suppose today is 24.10.2023 then the histogram shows only 3 records for the same Location, but the table shows everything for that location including all the due date. I believe this is something with relationship to the Date Table. 

The table is to be used for other Histogram as well (Open , Work in Progress, Delayed and Pending), so the table should fit for all.
I was thinking to create separate table specifically just for the Delayed, where I add the Y calculation in the table to filter accordingly.   
Is there any way to solve this where the table can fit for all?

[MFelix]

Hi @HeihoSilver ,

Have you tried using  the measure you have on the histogram has a filter on the table visualization?