I have a datetable and filters setup and is all good.(Please find attached the pbix file). Now I have a date relationship between DriverLog and AutoPosition already.
What I am trying : When a row is selected in the DriverLog(screenshot below), We need to Display any records on the AutoPosition table, irrespective of the Loc, show all the BusIds in the CreatedDate +/- 1 day range(As shown in the AutoPosition in the image). Important : I need the existing relationships.
I have tried DAX queries to create a table with the filtered valies, but couldnt get through.