cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Ayuda de dependencia circular

Me dicen que hay una dependencia circular entre Parentttl y ParentRatio. Ambos se están colocando sobre la mesa ItemDrillThrough. He usado ALLEXCEPT en el paréntesis e incluí la columna ParentRatio, pero todavía no funciona. Cualquier ayuda sería muy apreciada.

PARENTTTL =
var FcstDate = Hoy() + 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])))
Devolución
SUMX(summTbl2,[SubTtl])
ParentRatio = ItemDrillThrough[ParentSubttl]/ItemDrillThrough[ParentTTL]
1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

Lo siento a todos, acabo de averiguarlo.

Se agregaron Removefilters(ItemDrillThrough[ParentRatio]) como filtro dentro de CalculateTable para SummTbl2 y funcionó.

View solution in original post

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

Lo siento a todos, acabo de averiguarlo.

Se agregaron Removefilters(ItemDrillThrough[ParentRatio]) como filtro dentro de CalculateTable para SummTbl2 y funcionó.

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!