Forum Discussion
Circular dependency was detected
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
2 Replies
- AmiraBedh
Super User
Can you share your model, and your calculations as text and not images ?
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
