PowerPivot measure

Hi I recently got to know about PowerPivot, and i've been playing around with a bit for a few days now, and been googleing like hell to figure this out, but hasn't succeeded.

I have succesfully linked several data tables, and am now trying to create a measure to score a supplier data base on the performance regarding ability to deliver full on first delivery, and on time.

I have a column of the Qty supposed to be delivered, and one wit what was delivered. Furthermore I know what their stated lead time is, and the lead time deviation in weeks pr orderline.

How do i create a measure in powerpivot which scores like this:

If a delivery is fully delivered = 1 , if to little or too much = 0 And then i want the average of this score.

Same goes for ability to deliver on time, if the delivery is more than 1 week late = 0 and if it is earlier or on time = 1 , and again the average of all orderlines.

thanks

To attach an Excel file to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

I didn't say I will help. I said - attach example excel file