Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |