Help with table visual to table visual Edit Interactions behaviour

[Anonymous]

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.

[v-yulgu-msft]

Hi @Anonymous,

You can control the interaction between visuals by "Edit Interactions". Choose the top table visual in your scenario, then, disable the interact filter in second table visual.

Best regards,

Yuliana Gu

[Anonymous]

This doesn't acheive what I'm trying to do.

I would like to click on a record in the top table visual (each row in the top table visual is Grouped By the SCRIPT_ID showing the SCRIPT_ID details for the MAX (LOG_DATE)) which should then filter the bottom table visual to show all records for that clicked SCRIPT_ID from the top table.

For example,

If the user clicked on the row with the SCRIPT_ID of 1:

then the user should see in the bottom table visual all rows with a SCRIPT_ID of 1 and hide all other rows with different SCRIPT_ID values:

How do I acheive this?

Thanks.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

From my opinion, this requirement is not ahievable.

This table visual only have records with latest LOG_DATE. When you click the SCRIPT_ID of 1, it means current record where date is the latest one is chosen. Then, the related table visual will find out the same row to exactly match with it.

Regards,

Yuliana Gu

[Anonymous]

Okay, so it seems what I am trying to achieve cannot be done. That's fine. Thanks for the response.