Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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. ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.