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
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.
      • iamprajot's avatar
        iamprajot
        Responsive Resident
        8 years ago
        then isn't it correct as it counts when there are more than 2 instances.