Issue with Date filter when linking to dates to calendar table

[kkalyanrr]

Hello,

From the below sample table,
I want to present the jobs which are active between Opened date and closed date.
in the second chart I tried for the jobs between 01/02/2022 and 31/12/2025 but some how date filter is not working properly.

Here my requirement is in the second chart I should see the jobs circled in yellow as well as jobs which have no opening date and closing dates. Please help.
I'm providing the screenshot of the calendar table and its links.

[Jihwan_Kim · Accepted solution]

Hi, @kkalyanrr 

Please check the below pictures.

By seeing your screenshot, I cannot know which one is an active relationship and which one is an inactive relationship.

So, I decided to make both inactive relationships.

In my case, I prefer to make all inactive relationships if there are more than two date-related columns in one fact table. This makes me not to have any confuse which one is active and which one is inactive. If I want to activate one of those, I can simply use USERELATIONSHIP function.

In order to dynamically show the result by changing the date slicer, the measure is needed like below.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM