Circular Dependancy with If statement

Question

I can't understand where my dependancy is. I have 4 measures for running total...&nbsp;RT_800-1Dir = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR __date = max('Dept 800-1 Daily Time'[Date_Began])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR __Table = FILTER(ALLSELECTED('Dept 800-1 Daily Time'),'Dept 800-1 Daily Time'[Date_Began] &lt;= __date )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sumx(__Table,[Direct])&nbsp;RT_800-1Indirect = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR __date = max('Dept 800-1 Daily Time'[Date_Began]) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR __Table = FILTER(ALLSELECTED('Dept 800-1 Daily Time'),'Dept 800-1 Daily Time'[Date_Began] &lt;= __date )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sumx(__Table,[Indirect Time])&nbsp;RT_800-2Dir = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR __date = max('Dept 800-2 Daily Time'[Date_Began]) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR __Table = FILTER(ALLSELECTED('Dept 800-2 Daily Time'),'Dept 800-2 Daily Time'[Date_Began] &lt;= __date )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sumx(__Table,[Direct])&nbsp;RT_800-2Indirect = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR __date = max('Dept 800-2 Daily Time'[date_began]) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR __Table = FILTER(ALLSELECTED('Dept 800-2 Daily Time'),'Dept 800-2 Daily Time'[date_began] &lt;= __date )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sumx(__Table,[Indirect Time])&nbsp;I then have a table with two columns showing the RT&nbsp;The RTDir column works fineRT_Dir = if([Dept]="800-1",[RT_800-1Dir],if([Dept]="800-2",[RT_800-2Dir],0))&nbsp;However the RTInd is giving me an errorRT_InDir = if([Dept]="800-1",[RT_800-1Indirect],if([Dept]="800-2",[RT_800-2Indirect],0))&nbsp;&lt;ccon&gt;A circular dependency was detected: Combined Time 800[Column], Combined Time 800[RT_Dir], Combined Time 800[Column].&lt;/ccon&gt;&nbsp;I cannot figure out why one works and the other does not&nbsp;Thank You&nbsp;

v-luwang-msft · Accepted Answer

Hi&nbsp;Joe_Grosskopf&nbsp;，
In your case, Power BI does not allow to have two calculated columns that contain measures that are also based on that table. &nbsp;In order to understand why, you'd need a better understanding of what's going on under the hood.
Refer:
https://www.sqlbi.com/articles/understanding-circular-dependencies/&nbsp;

&nbsp;
&nbsp;
Best Regards
Lucien

Forum Discussion

Circular Dependancy with If statement

2 Replies

Related content

Circular dependency

Circular Dependency

DAX Help - Circular Dependency

Circular Dependency Error

A Circular Dependency was detected