Filter a date table, show dates from other tables without synchronized slicers

[Anonymous]

Hi folks!

I have the following data structure:

Structure

I would like to have a filter (page filter) to set year and month (date hierarchy) of the dates table and then show only data that was in the past for tickets and events.

I thought I could do somethingl like this:

Get the max value of selected Dates[Date] and compare each event/ticket date as calculated column if its less then max value of dates. But when I filter the dates those filter is not getting applied.

Therefore I created inactive relations and though I could use userelationship but then I got :

A circular Dependency was detected error while creating a calculated column

Avoid circle dependency errors in DAX

Do you have any hint how I could archive this in a correct way? I know I can do this by using synchronize slicers and group the dates to a specific slicers but I need to do it with filters.

Thank you in advance!

[amitchandak]

@Anonymous , ideally evens and ticket should not join and both tables should have single directional relation with date table (1 -M where date table is on one side)

[Anonymous]

Hi amitchandak, yes sure this would be the ideal case but unforunatly this dataset was justn an example to show the need. My real example is like this:
Server (created date, ...)
Ticket (created date, affected server id)
so I need to have the relation between server and ticket but also I want users to be able to pick up a month they want to see and get server and ticket data on one or multiple page. Of couse I could say ok users then please select 2 fields there, but the problem is there are even more tables with the same approach with a link to an item and an additional date field. Thanks