Conditional remove duplicates based on another column in power query related to (power bi)

Hello
I'm new to Power Bi, and realise my power query tables do not have distinct rows. I would like to delete the duplicate rows based on the lower FTE after first summing the FTE. I have about 20 staff who have duplicate rows out of 150 staff, but I can't get the source data (SQL database) to change to alleviate this problem.

My attached small table shows my duplicate values and how I would like it to look so I can use if for a Power BI dashboard. Even if I could be guided towards some PD I would appreciate that. So far my google search has been fruitless.

Hi Alan
Thanks for replying.
I don't think I was clear. I would like the duplicated row to be deleted after it has summed the FTE value of both rows, pertaining to the same ID (Staff member) and then the row remaining is the higher fte row. The order of each row for the same employee may be random, so deleting the first or second row won't work either. Hopefully that helps with my predicament.

Thanks Alan
It works for merging the IDs and totalling the FTE. However, it isn't sensitive to the higher FTE being the distinct row I need. i.e. if I reverse the fte for ID 6111 it still gives me the Teacher instead of the ES officer. Unfortunately, I need the higher FTE due to Leave records being included at 0 FTE which I don't want to remain.
Does that make sense? I may need some sort of max formula in there!!!

Thanks for trying Alan.

Thanks Ali
Sorry I didn't get back to you last night, but kept getting a HTTP 500 error within the site.

Yes, it is exactly what I need to go ahead with a distinct table for Power BI fun.

Thank you to you and the forum moderators who are real experts. I'll now mark the thread closed.