Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
I'm very new to PowerBI and in my previous post i want to calculate a SLA score for my telephone. Now i made 4 colums:
AcceptedQueuetime = calculate(countrows(PowerBI_Customer_Last180Days); PowerBI_Customer_Last180Days[queuetime]<20)
Missed = sum (PowerBI_Customer_Last180Days[MissedCalls])
Accepted = sum (PowerBI_Customer_Last180Days[AcceptedCalls])
SLA = DIVIDE(PowerBI_Customer_Last180Days[AcceptedQueuetime];(PowerBI_Customer_Last180Days[Accepted]+PowerBI_Customer_Last180Days[Missed]))
Here is my table with columns:
But when i click the SLA column i get the message:
A circular dependency detected: PowerBI_Customer_Last180Days[AcceptedQueuetime]; PowerBI_Customer_Last180Days[SLA]+PowerBI_Customer_Last180Days[AcceptedQueuetime]
What is wrong with the calculation i'll hope someone can help me
Hi @jopper1988,
You can take a look at below blog which told about circular dependency error:
Understanding Circular Dependencies in Tabular and PowerPivot
Regards,
Xiaoxin Sheng