Circular dependency was detected

[VikasD10]

I have table names as "Detail" in that table contains ID,Status and Date time.

I have created one Column (I attached snip Dax in Attachment). Calculated one more Coloum"Detail_rank"that concatinat ID and Rank number

I have another"Check" table that also has ID,Status and Date time.in that table also I have created one Coloum (attached snip).Calculated one more Coloum "Check_rank" that concatinat ID and Rank number.

I was trying to create Many to one  relationship between Check_rank(many) and Detail_rank(unique) but giving A circular dependency was detected error while creating relationship 

Below is dax for Ra

 

Below is the Dax in Check table which create Rank

 

 4.17 MB of 4.69 MB

[VikasD10]

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

[AmiraBedh]

Can you share your model, and your calculations as text and not images ?