Forum Discussion

Frequent Visitor

3 years ago

Solved

Line Item Fill rate

Hello,

I need help in finding the Line Item Fill Rate, please help me!

I have the columns, Order_id, Product_id, Order_qty, delivery_qty, in_full (full product quantities delivered).

Line Item Fill Rate = # of customer order lines filled completely / total # of customer order lines.

My understanding:

Filter order_id, then, Countrows(In_Full = 1) / countrows(filter order_id)

Here is the picture of the data, thanks in advance!

Anonymous
3 years ago
measure=

var countinfull=calculate(countrows(TableName),TableName[In_Full]= 1)

var total = countrows(TableName)

return

divide(countinfull,total,0)

3 Replies

Anonymous
Not applicable
3 years ago
Hi

measure=

var countinfull=countrouws(filter(order_id),oreder_id(In_Full = 1))

var total = countrows(order_id)

return

divide(countinfull,total,0)
- singaramharish
  Frequent Visitor
  3 years ago
  This isn't working,
  The formula is "Number of order lines shipped In Full Quantity / Total Order Lines"
  Here The line fill rate = 2/3
  Please help with dax
  - Anonymous
    Not applicable
    3 years ago
    measure=
    
    var countinfull=calculate(countrows(TableName),TableName[In_Full]= 1)
    
    var total = countrows(TableName)
    
    return
    
    divide(countinfull,total,0)