DAX issues

[Anonymous]

Hi

How to resolve below DAX Query issue.

ProjectRisk =  IF([max]=2 , "off Track"

                      IF([max]=1 || project[budgethourtilldate]-project[actualhours]<0

                                       || project[free resource]>0, "At risk" , " on track" ))

Getting " A circular dependency was detected: project[projectrisk],[project[freeresource], project[projectrisk]

Thanks

kunuthu

[v-yuta-msft]

Hi kunuthuri,

Please check if project[freesource] is a calculate column which also depends on project[projectrisk] and other columns.

For details, you can refer to https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/.

Regards,

Jimmy Tao

[Phil_Seamark]

HI @Anonymous

Is your 'project'[free resource] a calculated column?