How can I use a "neutral" date filter for 2 different date tables

[llaprosper]

Hello all,

I have a problem which I just can't solve.
I am querying a SQL database for a ticketing system. There are 2 columns. Once when the ticket was opened (CreatedDate) and once when the ticket was closed (ClosedDate).
Now I want to create a report where I can enter a date range or a fixed date and see how the ratio of opened to closed tickets is.
For this I have created 2 measures where I count the open tickets and once the closed tickets.
My problem now is, how do I create the date filter?

I can't use the date field of e.g. Created Date. If I select e.g. only one day, the result would be that ALL tickets are counted, where the Created Date = the filtered date is BUT only the closed tickets are counted, which were opened on the date of the filter. This is not supposed to be, because more tickets may have been closed on that day.

Do you understand my problem? Or did I express myself stupidly?

[some_bih]

Hi @llaprosper check community example as idea to organize your data and make calculation. hope this help

https://community.fabric.microsoft.com/t5/Desktop/Date-Difference-between-dates-from-multiple-tables... 

[llaprosper]

Thanks for the answer but unfortunately this is too complex for me to derive my solution from the example 😞