Forum Discussion
Circular dependency when working with primary keys
Hello all, I am currently trying to remove a circular dependency in Power BI and could not find any solution when doing some research. I am managing a dashboard for our project management off...
Hi,
I recommend cheking this article by SQLBI. They cover the reasons for these kinds of errors quite well: https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
ValtteriN
Community Champion
Community ChampionHi,
I recommend cheking this article by SQLBI. They cover the reasons for these kinds of errors quite well: https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Hey ValtteriN !
At first I thought the solutions provided in this articel did not help - turns out I had a syntax error in one of my columns.
Thanks a lot! Replacing ALL with ALLNOBLANKROW within the CALCULATE function did help indeed.
Kind regards
Marcel