Ranking using partition from relationship

I have a table of item details, and a table of events, which are either good or bad (1 or 0). There is a one-to-many relationship between 'Details'[Item ID] and 'Events'[Item ID]   I'm trying to wr...