Forum Discussion
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, ...
Create a new Table from Modeling,
Table =
SUMMARIZE(FOI,FOI[Supplier_Name],"Supplier Name",IF( CALCULATE(COUNT(FOI[Return]),FILTER(FOI,NOT(ISBLANK(FOI[Return]))))>=2, CALCULATE(COUNT(FOI[Return]),FILTER(FOI,NOT(ISBLANK(FOI[Return])))),BLANK()))
Table =
SUMMARIZE(FOI,FOI[Supplier_Name],"Supplier Name",IF( CALCULATE(COUNT(FOI[Return]),FILTER(FOI,NOT(ISBLANK(FOI[Return]))))>=2, CALCULATE(COUNT(FOI[Return]),FILTER(FOI,NOT(ISBLANK(FOI[Return])))),BLANK()))
Thanks for your feedback!
when you say FOI[Return] you mean the unioque field in the table?
it should count the part number right?