Forum Discussion
Helper IA circular dependency was detected:
Hello.
I have a table with Country, Currency, Program, Partner Type, Product, Billing Month, Incentives Month, Rate, Revenue (measure = sum (table[subotal])), Incentives (measure = table[Revenue]*0.05), Revenue $ = [Revenue]/table[Rate] and when i try to create the Incentives $ = [Incentives]/table[Rate] I get the error <pi>A circular dependency was detected: table[Incentives $], table[Revenue $], table[Incentives $].</pi>
Is there any way i can make this work?
I checked online, but i wasn't able to find a solution.
Thank you
Hi vbis ,
Circular dependencies are detected whenever two objects refer to each other, so that Power BI cannot process these objects.
This is a good refresher on circular dependencies:
Understanding circular dependencies in DAX - SQLBI
If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-henryk-mstfCommunity Support
Hi vbis ,
Circular dependencies are detected whenever two objects refer to each other, so that Power BI cannot process these objects.
This is a good refresher on circular dependencies:
Understanding circular dependencies in DAX - SQLBI
If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.