Forum Discussion

Varan_15's avatar
Varan_15
Helper III
1 year ago

PI circular dependency error

Hi All,   I have customer tickets table like below base on entry and exit i created 2 measures (1.total hours spent  and 2. allocated sla hours) based on that i created result column which will sho...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Varan_15 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

Beyond Time Bucket =
VAR additionalday =
    CALCULATE (
        SUM ( 'Test'[M_Additional Hours] ),
        FILTER ( 'Test', 'Test'[result] = "Beyond SLA" )
    )
VAR testing =
    IF (
        NOT ( ISBLANK ( 'Test'[M_Additional Hours] ) ),
        DIVIDE ( additionalday, 8, 0 )
    )
VAR Day_Bucket =
    SWITCH (
        TRUE (),
        testing <= 2, 2,
        testing > 2
            && testing < 5, 5,
        testing > 5
            && testing < 10, 10,
        11
    )
RETURN
    IF ( NOT ( ISBLANK ( 'Test'[M_Additional Hours] ) ), Day_Bucket )

Best Regards

Varan_15's avatar
Varan_15
Helper III
1 year ago

Anonymous ,

 

Thanks for your effort, please note M_additional_Hours field is a measure and when i used the same again getting same error.
as below calculated column :

Beyond Time Bucket =
VAR additionalday =
CALCULATE (
'Final'[M_Additional Hours],
FILTER ( 'Final', 'OM_TI Final'[M_SLA_Result] = "Beyond SLA" )
)
VAR testing =
IF (
NOT ( ISBLANK ( 'Final'[M_Additional Hours] ) ),
DIVIDE ( additionalday, 8, 0 )
)
VAR Day_Bucket =
SWITCH (
TRUE (),
testing <= 2, 2,
testing > 2
&& testing < 5, 5,
testing > 5
&& testing < 10, 10,
11
)
RETURN
IF ( NOT ( ISBLANK ( 'Final'[M_Additional Hours]) ), Day_Bucket )

 

error:
<pi>A circular dependency was detected: Final[Beyond Time Bucket].</pi>

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Varan_15 ,

    Please update the formula of measure [Beyond Time Bucket] as below and check if it can return the correct result...

    Beyond Time Bucket = 
VAR additionalday =
  SUMX(
       FILTER ( 'Test', 'Test'[result] = "Beyond SLA" ),
       [M_Additional Hours]
    )
VAR testing =
    IF (
        NOT ( ISBLANK ( 'Test'[M_Additional Hours] ) ),
        DIVIDE ( additionalday, 8, 0 )
    )
VAR Day_Bucket =
    SWITCH (
        TRUE (),
        testing <= 2, 2,
        testing > 2
            && testing < 5, 5,
        testing > 5
            && testing < 10, 10,
        11
    )
RETURN
    IF ( NOT ( ISBLANK ([M_Additional Hours] ) ), Day_Bucket )

    Best Regards

    • Varan_15's avatar
      Varan_15
      Helper III
      1 year ago

      Anonymous ,

       

      Thanks for the update, But still no luck having same error.

       

      Please note for your information i have some more calculated columns and measures in the same table is that causing this error but while getting error it's not showing any particular column/ measure names.

       

      Thanks,

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Varan_15 ,

        Could you please share your pbix file(exclude the sensitive info) with us? We will then be able to investigate the cause of the error. You can refer the following link to upload the file to the community. Thank you.

        How to upload PBI in Community

        Best Regards