RANKX Over 3 Fields. ID, DATE, TIME & Direction

Hi SNRCON81 ,

You can try below dax query.

EVALUATE
VAR vTb1 = 
	SELECTCOLUMNS(
		Sheet1,
		Sheet1[Id],
		"Date",FORMAT(Sheet1[Date],"dd/mm/yyyy"),
		"Time",FORMAT(Sheet1[Time],"hh:mm:ss"),
		"Index",ROUND(Sheet1[Date]+Sheet1[Time],4)&'Sheet1'[direction],
		Sheet1[Direction],
		Sheet1[RANK]
	)
VAR vTb2 = 
	ADDCOLUMNS(
		vTb1,
		"Grp",
			SUMX(
				FILTER(vTb1,[Index]<=EARLIER([Index]) && 'Sheet1'[id]=EARLIER('Sheet1'[id])),
				VAR CurId = 'Sheet1'[id]
				VAR CurIndex = [Index]
				VAR CurDirection = 'Sheet1'[direction]
				VAR PreDirection = 
					MAXX(
						TOPN(1,FILTER(vTb1,'Sheet1'[id]=CurId && [Index]<CurIndex),[Index]),
						'Sheet1'[direction]
					)
				RETURN
				IF(CurDirection<>PreDirection,1,0)
			)
	)
RETURN
ADDCOLUMNS(
	vTb2,
	"NEW RANK",
		RANKX(
			FILTER(vTb2,'Sheet1'[id]=EARLIER('Sheet1'[id]) && [Grp]=EARLIER([Grp])),
			[Time],,ASC,Dense
		)
)
	

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~