Forum Discussion
Solved
GENERATED Table
Hi, I created a GENERATED Table and I have a circular dependancy. I don't understand why. I can create a measure calling ALL(model) but not calling a specific model : CALCULATE( Q108...
clem312 this article from SQLBI may be of help to you:
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
The first thing I would try is replacing your "VALUES" functions with "DISTINCT" in your calculated table.
Hi Anonymous
Thank you. I had first solved it using FILTER instead of comma.
But your answer is a great help as I have other tables where the blank row issue that is mentioned in you article would have occured.