Line Item Fill rate

[singaramharish]

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]

Hi

measure=

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

var total = countrows(order_id)

return

divide(countinfull,total,0)

[singaramharish]

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 · Accepted solution]

measure=

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

var total = countrows(TableName)

return

divide(countinfull,total,0)