Forum Discussion
Circular Reference - driving me mad!!!!
Here is my file - TEST.PBIX YOu will see it is very simple. I have a data table with 2 values in it "Labour" and "Material" and another table with "One", "Two", "Three", "Four" I have cre...
Circular Dependency while creating relationships, gets generated, when you use to create such calculated tables, which handles invalid relationships by introducing a "Blank" like VALUES() function.
Check out this Post where you will get to know, how a use of CALCULATE() in calculated columns, or above calculated tables, can create circular dependency and the solution for the same.
https://youtu.be/CQHcZFk7pXc (Circular Dependency Breaker DAX Functions)
We post amazing Power BI and DAX solutions on this you-tube channel check it out for more.
https://www.youtube.com/@PowerBIHelpline/