Forum Discussion
A Circular Dependency
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:
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.
3 Replies
I think use DAX Formatter and format your code and post it. It will be easier to troubleshoot.
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
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.
