Circular dependency was detected

Rank_Deatil SWITCH (

TRUE (),

Deatil [Task Activity Name] = "Complete",

RANKX (

FILTER (

ALL (Deatil),

Deatil[ID] EARLIER (Deatil [ID]) && Deatil [Task Activity Name] = "Complete" ,

) Deatil [Activity Status Date Time), ASC ,

) Deatil [Task Activity Name] = "Reassigned", RANKX (

FILTER (

ALL (Deatil),

Deatil [ID] EARLIER (Deatil [ID]) && Deatil [Task Activity Name] = "Reassigned" ),

Deatil [Activity Status Date Time], ASC

) + 100,

Deatil [Task Activity Name] = "Cleared", RANKX (

FILTER (

ALL (Deatil),

Deatil [ID] EARLIER (Deatil [ID]) && Deatil [Task Activity Name) "Cleared" ),

Deatil [Activity Status Date Time), ASC )+ 1000,

Deatil [Task Activity Name] = "Delete", RANKX (

FILTER (

ALL (Deatil),

Deatil [ID] EARLIER (Deatil[ID]) && Deatil[Task Activity Name] "Delete" ),

Deatil [Activity Status Date Time), ASC

) + 2000,

9999 // Default rank for other activities