Multiple record Measure help please

Hello , I was hoping someone could help please.   I have a three columns : ID, State and Part.  I need to create a fourth column that relies on the previous three collumns returning specific crtier...