Not sure what your intent is once you have the Max ID.
I did it one way making it just a MAX of the ID Dimension field (since ID is an integer, the logical MAX gets the result you want).
If you need to be able to get to the dimension value of the ID, then I created a filter that employs the LAST() table calculation to partition the table by User, then only allowed the record associated with the Last (maximum) record to show.
Do either of those get you what you need?
Max ID.twbx 336.5 KB
I think i am on the right path now. But am not sure how to only allow the record associated with the last (maximum) record to show. Any additional insights that you can provide related to this piece. Thanks!
If you take a look at the last tab in the workbook I attached, there is a filter in place using the calculated field to limit to the last row. Is that what you mean?