scratching my head about circular dependency

masplin — Wed, 25 Jan 2023 15:35:40 GMT

column folmula

App-Ref Lag = Applications[Reference Date]-Applications[Application Date]

based on 2 columns

Application Date = CALCULATE(MAX('Candidate Journey'[Activity Date]),

FILTER(RELATEDTABLE('Candidate Journey'),

'Candidate Journey'[Journey Stage]="Website Application to Review" ||

'Candidate Journey'[Journey Stage]="Incomplete Application"))

and

Reference Date = CALCULATE(MIN('Candidate References'[Activity Date]),

FILTER(RELATEDTABLE('Candidate References'),

'Candidate References'[Status/Outcome]="Reviewed - Suitable"

USERELATIONSHIP(Applications[Application ID],'Candidate References'[Application ID]))

i had an active relationship in application date so turned it off and tried

Application Date = CALCULATE(MAX('Candidate Journey'[Activity Date]),

FILTER(RELATEDTABLE('Candidate Journey'),

'Candidate Journey'[Journey Stage]="Website Application to Review" ||

'Candidate Journey'[Journey Stage]="Incomplete Application"),

USERELATIONSHIP(Applications[Application ID],'Candidate Journey'[Application ID])

)

which then gave me a circular dep in that formula as well

Now all relationships are inactive. compeltely stumped. Any advice appreciated

topic scratching my head about circular dependency in DAX Commands and Tips