DAX calculate based on related table column value

[olof]

Hi

I have three tables; Foo, Bar & Baz, as illustrated bellow.

I'm looking for how I will be able to create a new boolean column, on Baz table, that determine if Baz's row has the latest CreateDate between others with a relation to FooId.

Currently, my DAX formula on the Baz table looks as follow:

Latest = 
    var fooId = LOOKUPVALUE(Bar[FooId]; Bar[BarId]; Baz[BarId])
    return CALCULATE(
        MAX(Baz[CreateDate]);
        FILTER(
            ALL(Baz);
            LOOKUPVALUE(Bar[FooId]; Bar[BarId]; Baz[BarId]) = fooId)
    ) = Baz[CreateDate]

The problem with the current DAX formula is that I get a warning; A circular dependency was detected: Baz[Latest].

How could this problem be solved with a DAX formula?

[v-chuncz-msft · Accepted solution]

@olof ,

You may refer to the post below.

https://community.powerbi.com/t5/Developer/Circular-reference-issues/m-p/580337#M17832