Group By measure

[gkakun]

Hi all,

I have a problem with group by measure. 

I have a table called FOI- with Transaction ID (Unique), part number, Supplier Name, location of the part, failure reason, failure timestamp, and more descrptive fields of the part. 

Eventually i need to get a table with supplier name and the number of parts which failed more than twice. 

For example - Supplier XXX-->6 (for this vendor, 6 units failed more than twice) 

Im thinkign to use the group bt with few iterations, but cant find the right way to do that. 

Any idea?