Forum Discussion
Filter Table visual by Inactive Date relationship
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.
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.
3 Replies
Anonymous , if interaction is off , then you will not get that value in measure to do calculation
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.
