Forum Discussion
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 :
- Anonymous4 years ago
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.
2 Replies
- AnonymousNot applicable
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. - clem312Resolver I
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.