Table filter using Two Table Dates with one Inactive Relationship to Calendar

[lorasloan]

I have a table that uses two table dates that have an active and an inactive relationship to calendar table.  

In my table visualization are measures for Open and Closed that are attached to different dates.  I have both working properly with using Userrelationship function for the inactive relationship.  

Now I need to add a filter (not slicer) on table to limit the dates.  If I use the Year/Mo from the calendar table it only applies to the active relationship values.  

How can I add filter where it uses both dates?  

[amitchandak · Accepted solution]

@lorasloan , if you apply to the date table, it should work for both, as inactive join can only work using userelationship and at that time it is having join with date.

[amitchandak · Accepted solution]

@lorasloan , if you apply to the date table, it should work for both, as inactive join can only work using userelationship and at that time it is having join with date.

[lorasloan · Accepted solution]

@amitchandak 

I  stand to be corrected.  The issue is with the Month End measure that you actually helped me resolve from another post I made.  This is the code for that measure you provided:

Month end = CALCULATE([Open] -[Closed],filter(allselected(date),date[date] <=max(date[Date])))

Since I'm filtering on date for visual, I used 'all' instead of 'allselected' and it is now working properly.  

Appreciate your expert knowledge.