Rank groups within unique IDs and by date

Hi jimminy ,

Here's my solution.

1.Create an index column in Power Query.

2.Go back to Power BI Desktop and create two calculated columns.

Column = 
IF(
    'Table'[Index]=
MINX(
    FILTER(ALL('Table'),'Table'[ticket_id]=EARLIER('Table'[ticket_id])&&'Table'[Service Team]=EARLIER('Table'[Service Team])),[Index]),1,0)

Final Rank = 
SUMX(
    FILTER(ALL('Table'),
    'Table'[ticket_id]=EARLIER('Table'[ticket_id])&&'Table'[Index]<=EARLIER('Table'[Index])),[Column])

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.