Circular dependancy: Can't figure out why it occurs..

[Anonymous]

Hi!

So I'm stuck with a circular dependancy that I cant figure out. I'm working on some order data and trying to allocate costs down to order row level. I first allocated a base rate per order down to order row level (worked fine), then I'm trying to apply same logic to shipping cost, however, that's when I get a circular reference I don't understand.

Key measures:

Total order rows per order =

  VAR __id = calculate(max('Sales'[order_id]), filter(Sales,Sales[sale_line_type]="product"))

  VAR __skus = FILTER(ALLSELECTED('Sales'),[variant_sku] <> BLANK() && [order_id] = __id)

RETURN

  COUNTROWS(__skus)

Order cost per row = calculate(divide(Pick_Pack[Pick&Pack base rate per order], [Total order rows per order])

)

Pick&Pack costs and Shipping costs have no overlap so the issue seems to be Total order rows per order.

Any thoughts?

Thanks! 

[amitchandak]

@Anonymous , Create a measure using the measure. Do not use them in calculated column

You can do line level calculation like

Sumx(Table, [Measure1]+ [Measure2])

[Anonymous]

@amitchandak I'm afraid this doesn't really help me. Not sure even where to start.

First of all, measures uses different tables. (total rows per order uses Order Data table for example).