Forum Discussion
Group By measure
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, ...
then isn't it correct as it counts when there are more than 2 instances.
Hi, Thanks again for the support.
i think it may be issue with the formula since i cant see any Supplier in the supplier Name column.
This is the formula
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()))
In the "Supplier Name" column i see only the count of the part