Forum Discussion

sowjanya123's avatar
sowjanya123
Frequent Visitor
2 years ago

Circular dependency error in calculated column

Hi,

I need help on resolving circular dependency error :

Below is the calculated column: 

Retro Test Support =
SWITCH(TRUE(),
[FraudPoint LY Revenue]>=100000 && Fraudpoint_Customers[Customer Type Flag]=0,"National Support",
[FraudPoint CY Revenue]>=10000 && Fraudpoint_Customers[Customer Type Flag] = 1,"Strategic Support"
)
FraudPoint LY Revenue is a measure : 
FraudPoint LY Revenue = CALCULATE([Sum of LY Revenue],FILTER(Fraudpoint_Customers,DISTINCTCOUNT(Fraudpoint_Customers[customer_account_sk])))
Sum of LY revenue is also a measure:
Sum of LY Revenue = CALCULATE([Total Revenue], FILTER(ALL('Date'), 'Date'[Closed Revenue Index by Year]=-1))
Total Revenue is also a measure:
Total Revenue = CALCULATE(SUM('fact_revenue_usage'[Total Billed Charges]),FILTER(Customers,DISTINCTCOUNT(Customers[customer_account_sk])))
 
Looking forward for help on how to fix the circular dependency error coming in Retro Test Support calculated column

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Please explain what this part is supposed to achieve

    FILTER(Fraudpoint_Customers,DISTINCTCOUNT(Fraudpoint_Customers[customer_account_sk]))