DAX issues

Question

Hi&nbsp;How to resolve below DAX Query issue.&nbsp;ProjectRisk =&nbsp; IF([max]=2 , "off Track"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF([max]=1 || project[budgethourtilldate]-project[actualhours]&lt;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || project[free resource]&gt;0, "At risk" , " on track" ))&nbsp;Getting " A circular dependency was detected: project[projectrisk],[project[freeresource], project[projectrisk]&nbsp;Thankskunuthu

phil_seamark · Answer

HI&nbsp;Anonymous&nbsp;Is your 'project'[free resource] a calculated column?

v-yuta-msft · Answer

Hi kunuthuri,&nbsp;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/.&nbsp;Regards,Jimmy Tao

Forum Discussion

DAX issues

2 Replies

Related content

DAX Issue

DAX code issue

DAX issue ISBLANK

Basic DAX Issue

Matrix calculation Issue - DAX