Thank you for the ideas Mike!
ROW_NUMBER() OVER(PARTITION BY Part.PartNum ORDER BY VendPart1.BaseUnitPrice ASC)
Dumped it into a dashboard to do some more filtering
Result is what I need, list all parts where there is a better price with an alternate supplier.
