Forum Discussion
PI circular dependency error
Hi Varan_15 ,
Base on your description, it seems you got the circular dependancy error when create a measure or calculated column? Could you please provide the formula of measure/calculated column which you got the error and your expected result? Later we can check it and give you a suitable solution.
In addition, you can refer the following blogs to deal with circular dependancy error.
Understanding circular dependencies in DAX - SQLBI
Avoiding circular dependency errors in DAX - SQLBI
Circular Dependency between Calculated Columns in ... - Microsoft Fabric Community
Best Regards
Anonymous ,
Thanks for the update, Lest say wherever Result Beyond SLA then obiouesly having addtional Hours in the scenario the below table second customer id result is beyond SLA so measure contains 5 hours additonal i want to create calculated clumn day bucket when i tried it's coming pi cisculart dependency error.
table :
| Customer | workstep | Products | Entry | Exit | result |
| 11220 | input | nic | 01/08/2024 15:35 | 01/08/2024 15:43 | within SLA |
| 11220 | process | nic | 01/08/2024 15:43 | 05/08/2024 13:27 | within SLA |
| 11220 | pending | nic | 05/08/2024 13:27 | 05/08/2024 13:52 | within SLA |
| 11220 | approved | nic | 05/08/2024 13:52 | 06/08/2024 14:05 | within SLA |
| 11220 | closed | nic | 06/08/2024 14:05 | 06/08/2024 15:22 | within SLA |
| 566060 | input | llc | 01/07/2024 15:35 | 01/07/2024 15:43 | Beyond SLA |
| 566060 | process | llc | 01/07/2024 15:43 | 05/07/2024 13:27 | Beyond SLA |
| 566060 | approved | llc | 05/07/2024 13:27 | 05/07/2024 13:52 | Beyond SLA |
| 566060 | closed | llc | 05/07/2024 13:52 | 06/07/2024 14:05 | Beyond SLA |
ex:
Beyond Time Bucket =
VAR testing = IF('Test'[M_Additional Hours] = BLANK(),0, DIVIDE( additionalday,8,0) )
VAR Day_Bucket = SWITCH(TRUE(),
testing <=2, 2,
testing >2 && testing <5, 5,
testing >5 && testing <10, 10,
11)
RETURN
Day_Bucket
for the testing expected result will be 2 day should show 1 count ( as we have 5 hours additional hours so divide by 8 will be 0.6 then its under <2 days bucket) .
Kindly suggest.