Hello members,

I have two fact tables and using DAX I could relate them by date. I am trying to use power pivot and the objective is to filter a well string not flowing HRS=0. When one date is chosen from the filter only not flowing wells get filtered. Then map the latest Close/ D event date to the table and the remark reason. For example, Filter on the date 10-Nov-2023, only one well FA001 is closed or down should appear. The well closed last on 7-Nov from the EVENT table that date should filter out in the pivot table. I am not able to achieve the same. When I use calendar date as a filter the wells don't get filtered.
Being a novice I am not able to understand what is going wrong. Looking for kind advice. Sample file latest-1 attached.latest-1.xlsx
Regards