Error with filter in dataset

I have a dataset that contains multiple records for users. I only want the latest record for each user and I’m trying to do this at the dataset level.

I have a calculated field that calculates a row number for each user based on an UpdateTimestamp field:
Row number

I then assign a value of 1 to the latest record:
Latest record

When I try to filter by Latest Record, I get a syntax error:

Is this because there are restrictions on what can be used as a filter in a dataset?

Thank you for reaching out. This is a known limitation, rank is an aggregation expression and currently we don’t support filters for aggregated calculated fields. We will consider improving the messaging to avoid confusion and also explore possibility to add support in future.

can you try adding only the filter in analysis?