Forum Discussion

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