Solved: Circular Dependency

Anonymous · ‎07-16-2018

How does one go about troubleshooting where/why a circular dependency is happening and how to fix it? I get an error message that lists the columns involved which is nice but it doesn't help me in understanding how/why these two columns are bumping heads:

Neither one of these formulas reference nor depend on each other for any calculating so I don't know what the issue is...

Phil_Seamark · ‎07-16-2018

Hi @Anonymous

For a start, I would change to use the SWITCH function over your use of nested IF statements. This will make it easier - and I recommend formatting your calculation.

Once you have this, you can comment sections of the function to help isolate and quickly identify which part is causing the issue.

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Phil_Seamark · ‎07-16-2018

Hi @Anonymous

For a start, I would change to use the SWITCH function over your use of nested IF statements. This will make it easier - and I recommend formatting your calculation.

Once you have this, you can comment sections of the function to help isolate and quickly identify which part is causing the issue.

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Anonymous · ‎07-17-2018

@Phil_Seamark thank you! I'm not sure how it's working under the hood but changing my NPS Bonus from a nested if to a switch made the circular dependency disappear.