Forum Discussion
PI circular dependency error
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.
Hi All,
Can anyone help on this issue how to achive to create calculated column using measures without PI circular dependancy.
Thanks in advance
Varan