Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Show and Tell
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

If it is a calculated column then you may be able to push that into Power Query instead (with the added benefit that this avoids circular references).

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523