circular relationship

Hello powerbiexpert22, MattAllington provided the greatest guardrail when working as a modeler.  PijushRoy continued the advice on your self learning journey asked, and I will share the folowing, and refer you to a Community Forum Post from 2020 in which  d_gosbell a fantastic and  long time resource of the same vintage as MattAllington and others who worked through a teaching example:  Solved: Circular relationship - Microsoft Fabric Community

 

Nikola llic from his personal blog post, summed it up like this:

 

 

Circular dependency is one of the most annoying things in Power BI data modeling process! Whenever you create two objects that are dependent on each other, you risk running into this issue. Sometimes, determining what is the root cause may be a straightforward task, but in certain scenarios, it is necessary to understand nuances of the DAX way of doing things.

<https://data-mozart.com/in-the-power-bi-whirlpool-understanding-circular-dependencies/>

 

 

Avoid Circular Relationships. They_are_annoying. The simplest solution is to prevent circular relationships from occurring in the first place. Design your data model carefully to avoid creating loops where tables reference each other directly or indirectly.  Thoughtful design and understanding your data relationships are key to resolving circular dependencies.