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
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

      • Varan_15's avatar
        Varan_15
        Helper III
        1 year ago

        Anonymous ,

         

        Sorry to inform that the data source conected with SQL server could not be allowed to load hence i have shared sample data above.

         

        Thanks,