Get last value for each id

Hi akoita92 ,

According to your description, here's my solution.

1.Create a measure.

Check =
IF (
    MAX ( 'Table'[date] )
        = MAXX (
            FILTER ( ALL ( 'Table' ), 'Table'[ID] = MAX ( 'Table'[ID] ) ),
            'Table'[date]
        ),
    1,
    0
)

Put the measure in the visual filter and let its value to 1.

2.If one visual is not affected by another visual, one method is to not establish a relationship between the two tables, and another method is to cancel the interactions between the two visuals. Obviously the first method is not suitable for you. So first select the calendar slicer, then click the Edit interactions button under the Format ribbon.

In the upper right corner of the table visual, select the None button, then uncheck the Edit interactions button.

Get the expected result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.