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, Sure I changed the column names based on the data.

 

If the part appears in the report its failed, every record in the table is failure record. 

iamprajot's avatar
iamprajot
Responsive Resident
8 years ago
in that case above dax will work fine
  • 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.