Filter Table visual by Inactive Date relationship

[Anonymous]

I have a Line Chart which plots calculated measures from a Production Jobs table against 'Date'[Datevalue], where I've calculated the measures to plot on the Datevalue based on the job Created date. 

When I selected a date on that Line Chart visual I want to drive those dates as a filter to Table visual of the Production Jobs table info, however the active relationship between Date and ProdJobs is Datevalue-to-OpEndDate. So below I selected February 2021, and the table is filtered by OpEndDate February 2021, I want it to filter Created.

I've tried editing the Interaction to Off and using a custome measure:

IfFiltered = CALCULATE(IF(ISFILTERED(Date[Datevalue]),1,0),ALLSELECTED(Date[Datevalue]),USERELATIONSHIP(Date[Datevalue],ProdJobs[Created]))

and applying this to the Table visual filters, where IfFiltered is 1. This did not work however. 

Any help would be appreciated.  I CANNOT add a column, I'm working off a published dataset. 

[Anonymous · Accepted solution]

Figured it out. 

I created a measure on the ProdJobs table

CalcCreated = Calculate(MAXX(ProdJobs,ProdJobs[Created]),ALLSELECTED('Date'[Datevalue]),USERELATIONSHIP('Date'[Datevalue],ProdJobs[Created]))

In the Table visual I used this calculated measure for the Created date, and left the interactions between the two visuals ON. 

[amitchandak]

@Anonymous , if interaction is off , then you will not get that value in measure to do calculation

[Anonymous]

I tried it both ways, on and off, didn't work either way