Date table will not filter indirectly related table

[jamiehandelman]

Hi there - I have a more or less complicated model. 

As one of my visuals, I have a table that shows hours spent on each customer, as well as the amount invoiced for each customer. 

The date filter nicely filters the hours to show the exact number of hours spent during that time period, but it will not filter the amount invoiced. 

Date table is related to TimeTracking by the date (1 to many). TimeTracking is related to POTracking by the customer (many to many). POTracking also has a date column (called created). I tried deleting the relationship between TimeTracking and POTracking, and then relating the date table directly to POTracking (1 to many), but this did not work either. The data types for the dates are consistent throughout all tables. 

Does anyone know why this isn't working? Thanks!

[v-diye-msft]

Hi @jamiehandelman 

You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[jamiehandelman]

above is a screenshot of my relationships.