Circular Dependency Help

[Anonymous]

I'm being told there is a circular dependency between Parentttl and ParentRatio. These are both being put on the table ItemDrillThrough. I've used ALLEXCEPT in the parentttl and included the column ParentRatio, but it's still not working. Any help would be greatly appreciated.

PARENTTTL = 

var FcstDate = Today() + 180

var summTbl = CALCULATETABLE(SUMMARIZE(CapRes,CapRes[ITEMID],CapRes[refid],"TransDate",Min(CapRes[TransDate]),"Qty",min(CapRes[Qty])),CROSSFILTER('Date'[DateValue],CapRes[TransDate],NONE),CROSSFILTER(CapRes[WorkCenter],Facility[WorkCenter],NONE),CROSSFILTER(ItemDrillThrough[ItemNumber],CapRes[ITEMID],NONE))

var summTbl2 = CALCULATETABLE(SUMMARIZE(FILTER(ALLEXCEPT(ItemDrillThrough,ItemDrillThrough[ParentRatio]),ItemDrillThrough[ItemNumber]=min(ItemDrillThrough[ItemNumber])),ItemDrillThrough[FGItemNumber],ItemDrillThrough[ItemNumber],"SubTtl",SUMX(FILTER(summTbl,AND([TransDate]<=FcstDate,CapRes[ITEMID]=ItemDrillThrough[FGItemNumber])),[Qty])))

Return

SUMX(summTbl2,[SubTtl])

ParentRatio = ItemDrillThrough[ParentSubttl]/ItemDrillThrough[ParentTTL]

[Anonymous · Accepted solution]

Sorry everyone, just figured it out.

Added  Removefilters(ItemDrillThrough[ParentRatio])  as a filter inside the CalculateTable for SummTbl2 and it worked.