Supplier Performance

Hi I am attempting to make a tool using Power Pivot, to measure my suppliers performance.

I have attached and example sheet. What i want to calculate is CVP - Confirmed Volume Performance. I want to check if my supplier, on the first delivery, delivers in full for the orderline, if he does he is score 1, if either too much is delivered og to little, score will be 0.

At the end and average score will be calculated. This gives me some headache, as an orderline might not be delivered in full, i only want to calculate CVP on the first attemt. For instance in my sample data, Bikes are delivered 3 times. 2 times for order 15214. 65 pcs was ordered, and 50 delivered, there for CVP = 0. About a month later the last 15 are delivered, but as this is a backorder i don't care, supplier already screwed up, so don't want to calculate that. Later another shipment of bikes are deliveres, this time in full therefore CVP is = 1, and the average for all his deliveries for bikes is 0.5 = 50% of the orders the supplier delivers, the supplier deliver in full.

I need to filter it somehow to only calculate the average, based on the earliest arrival date for a specific orderline i think, but i am still very new to DAX, so struggling a bit to figure this out.

There is another sheet in the sample as well. Don't mind that, I need that later for something else, that I think I know how to do

Succes

I managed to get it working myself. However, only if my item references are only made of numeric values. My real world values, are not the case like this. How do i make it work with text strings as well?

Also, i am not sure if what i made is that beautiful, perhaps a nicer code can do the same or?

Aparrently

I didn't succeed completely.

I have an issue with calculting a correct OTP value. In attached sheet, i need it to be 100%. I only want it to SUM the first date entry, based on the earliest delivery. In the attahced sheet however, it sums both lines that exist for this item reference. Which causes the OTP to be 200%.

2/1 = 2. But it should be 1/1, as the second delivery of the order i don't care for. How do i apply correct filter, so it only sums up values, based on first date of delivery. I thought i figured it, but apparently not.