A Circular Dependency

[Anonymous]

When building this formula, I've gotten this error:

But I'm just lost on why this is happening and how to fix it because this formula doesn't depend on NPS Bonus so I don't know why it's saying so:

[v-piga-msft]

Hi @Anonymous,

You could have a reference of this similar thread which has been solved.

If you still need help, please share some data sample and your formula, so that we can help further investigate on it?

Best Regards,

Cherry

[Anonymous · Accepted solution]

Hi @v-piga-msft I've since then figured out the answer to my own problem. I'm still not sure how or why it works, but another user suggested using Switch statements instead of nested IF statements and it ended up working. Didn't change anything about the logic at all:

 

It works now, I'm just confused on when and why to use SWITCH vs. IF. I'm using nested IF statements on a different dashboard with the exact same formulas and they work fine.

[Kasunpathirana]

I think use DAX Formatter and format your code and post it. It will be easier to troubleshoot.

http://www.daxformatter.com/