DAX Help - Circular Dependency

Basically, what is happening here:

“To calculate A I need B, but to calculate B I need A.”

That creates a loop — and DAX does not allow loops in calculated columns.

Proposed solution:

DIVIDE(

Market Share :=

DIVIDE(

    SUM(CustomerModelShare[Total Cust Model Build]),

    SUM(CustomerModelShare[Total Cust Build])

)







Cust Monthly Model Build :=

IF(

    SELECTEDVALUE(CustomerModelShare[Truck Category]) = "CL8",

    SUM(CustomerModelShare[Cust Mthly Build]) * [Market Share]

)

Now there is:

• No column referencing another column
• No row-by-row dependency
• No circular logic

You created a loop in stored columns.
Move the logic to measures and let Power BI calculate it dynamically.

If this helps, ✓ Mark as Kudos | Mark as Solution| Help Others

You’re getting the circular dependency because you’re mixing calculated columns that depend on other calculated columns which (directly or indirectly) depend back on the first one. 

Market share and “monthly model build” are aggregations and should typically be measures anyway.

Market Share =
DIVIDE( [Total Cust Model Build], [Total Cust Build] )

Total Cust Model Build =
SUM ( CustomerModelShare[Total Cust Model Build] ) 

Total Cust Build =
SUM ( CustomerModelShare[Total Cust Build] )

Cust Monthly Model Build :=
IF(
    SELECTEDVALUE(CustomerModelShare[Truck Category]) = "CL8",
    [Cust Mthly Build] * [Market Share],
    BLANK()
)

Cust Mthly Build =
SUM ( CustomerModelShare[Cust Mthly Build] )