Time-sheet Report - Remove duplicates from visualisation

[Anonymous]

Hello,

Context: 

I'm working with data from a CAFM System which logs all timerecords against a task (Many timerecords to one task). I'm trying to see how many tasks each engineer has at a given time

See photo below where the 2nd column (F_TASKS.TA_SEQ) has duplicated, I only wish to see the record with the MAX TT_STARTED. 

The issue is that the highlighted record 637942 may be assigned to 18 other RES_NAME so if I use MAX function in dax on the table it removes the other 17 resources.  

I need a function that will use MAX on the TT_STARTED but is relative the RES_NAME Slicer. 

Any suggestions will be appricated, example data can be sent over too.  

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may use RANKX to add a measure and then take advantage of Visual level filters.