How to get total no order rows for order to show on each row

[Anonymous]

Hi! Most likely a stupid question..Anyways, here we go

So I'm trying to calculate the total pick and pack cost per product. There is a base rate per order, however I want to allocate the order cost equally per order row/product.

See below picture. In this example I want order rows to say 3 on each line level in order for me to then allocate correctly.

I tried calculating it like this 

Order rows = calculate(COUNTROWS(Sales),

filter(Sales, Sales[order_id])

This should be easy but somehow I get stuck. So "order rows" should show, on each variant_sku the total number of order rows for the order_id. Then I can allocate out the order cost per sku.

Thanks in advance

[Greg_Deckler · Accepted solution]

@Anonymous Maybe:

Order rows = 
  VAR __id = MAX('Sales'[order_id])
  VAR __skus = FILTER(ALLSELECTED('Sales'),[variant_sku] <> BLANK() && [order_id] = __id)
RETURN
  COUNTROWS(__skus)