GENERATED Table

[clem312]

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[%Q108],

'model'[lib_model] IN {"Connect", "Transit Custom", "Transit", "Transit MHEV", "Transit Tourneo"}

),

makes a circular dependancy.

[clem312]

Hi @ebeery 

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. 

[ebeery · Accepted solution]

@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.