Forum Discussion
Calculated columns - Circular dependencies
Avg_ob_load_distinct = sumx(DISTINCT(Crossdock[LD_LEG_ID]), FIRSTNONBLANK(Crossdock[AVG_OUTBOUND_LOAD],0)) Avg_ib_load_distinct = sumx(DISTINCT(Crossdock[LD_LEG_ID]), FIRSTNONBLANK(Crossdock[AVG_IN...
Ashish_Mathur
Super User
Super UserHi,
Write these measures
AOL = min(Crossdock[AVG_OUTBOUND_LOAD])
Average AOL = AVERAGEX(VALUES(Ld_LEG_ID),[AOL])
Hope this helps.