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

I have tried this one and got this error (with FOI[IPN] instead if FOI[Return])

 

Function SUMMARIZE expects a column name as argument number 3.

iamprajot's avatar
iamprajot
Responsive Resident
8 years ago
Return is failure reason of your data,
please change the column name according to your data.
also tell me how you identify if a transaction is failed, as basis of that the dax will work.
  • 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.