Trying to create a schedule table view in Power BI in a matrix with: Columns: Scheduled_Date Rows: Loacation, Employee_Number Values: Start-End_Time_Activity

Table used: Schedules Columns: Employee_number Scheduled_Date Activity_Code Hours Activity_start_time Activity_end_time

For the value measure I am able to get the schedule start and end time without a problem.

How can I add the longest activity for that day for that employee, ranked by sum(hours)?

I've tried Bing chat and other forums with no success. I can add Activity_Code as a separate value in Rows, and do a topn filter, but I prefer having it as a value instead.

Any thoughts?