Forum Discussion

gkakun's avatar
gkakun
Helper III
8 years ago

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, ...
Need Help
gkakun's avatar
gkakun
Helper III
8 years ago

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.

 

 

 

 

iamprajot's avatar
iamprajot
Responsive Resident
8 years ago
it isn't clear from the snapshot, what is the issue but looks like MAX and Count cannot result in same value in Totals
  • gkakun's avatar
    gkakun
    Helper III
    8 years ago
    Tge left table counts the number this part failed in the original table and the right table is the new table where you see the number failures of this spesific part is not correct. Its the same result if i dont use the max but dont summarize.
  • iamprajot's avatar
    iamprajot
    Responsive Resident
    8 years ago
    then isn't it correct as it counts when there are more than 2 instances.
  • gkakun's avatar
    gkakun
    Helper III
    8 years ago

    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