Help with table visual to table visual Edit Interactions behaviour

Hi,

I have created a calculated table which holds all entries where the SCRIPT_ID has had a status of 'NOT_FOUND_IN_EPS'.

The DAX:
tblNotFoundInEPS =
     CALCULATETABLE (
          CALCULATETABLE (
               SUMMARIZE (
                    refSCRIPT_VALIDATION_LOG,
                    refSCRIPT_VALIDATION_LOG[id],
                    refSCRIPT_VALIDATION_LOG[syllabus],
                    refSCRIPT_VALIDATION_LOG[session_id],
                    refSCRIPT_VALIDATION_LOG[component],
                    refSCRIPT_VALIDATION_LOG[centre],
                    refSCRIPT_VALIDATION_LOG[candidate_number],
                    refSCRIPT_VALIDATION_LOG[check_type],
                    refSCRIPT_VALIDATION_LOG[submitted_at],
                    refSCRIPT_VALIDATION_LOG[status],
                    refSCRIPT_VALIDATION_LOG[AUDIT_TYPE],
                    refSCRIPT_VALIDATION_LOG[LOG_DATE],
                    refSCRIPT_VALIDATION_LOG[resolved_at],
                    refSCRIPT_VALIDATION_LOG[SCRIPT_ID]
),
        CALCULATETABLE (
                   SUMMARIZE ( refSCRIPT_VALIDATION_LOG, refSCRIPT_VALIDATION_LOG[SCRIPT_ID] ),
                                          refSCRIPT_VALIDATION_LOG[NOT_FOUND_IN_EPS] > 0
                                        )
                                     )
)

The result dataset example is:

I then create a measure to show in a table visual only a single entry from each SCRIPT_ID but this entry must the entry with the latest LOG_DATE value.
The DAX is:
mLatestStatus =
          VAR Latest =
               CALCULATE(
                     MAX( tblNotFoundInEPS[LOG_DATE] ),
                     ALLEXCEPT( tblNotFoundInEPS, tblNotFoundInEPS[SCRIPT_ID] )
                     )
RETURN
IF( MAX( tblNotFoundInEPS[LOG_DATE] ) = Latest, 1, 0 )

I filter the table visual to only show the entries with mLatestStaus = 1.

The returned dataset example is:

Now when I click on a row, say the row with SCRIPT_ID of 1. I would like the other table visual to show all rows when the SCRIPT_ID is 1. So in affect the top table visual shows only the latest status for each SCRIPT_ID and the bottom table visual shows the full audit trial for that same SCRIPT_ID.

However, when I try this the bottom table visual only shows the exact entry that matches the top SCRIPT_ID that's been clicked on. See example below:

How can I acheive what I'm trying to do?
Thanks in advance.