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.
Hi, Thanks again.
Now the formula works but the data is incorrect.
Table = SUMMARIZE(FOI,FOI[IPN],"Supplier Name",IF( CALCULATE(COUNT(FOI[IPN]),FILTER(FOI,NOT(ISBLANK(FOI[IPN]))))>=2, CALCULATE(COUNT(FOI[IPN]),FILTER(FOI,NOT(ISBLANK(FOI[IPN])))),BLANK()))
See for exmpale in the picture, part number 500257585, appears in the new table as 227 times while in the data is appears only 129 times.