Forum Discussion

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

COUNT formula to include BLANK

I have this formula for COUNT- Count = VAR T1=ADDCOLUMNS(VALUES(ULDs[Location]),"sum",[SUM TOTAL QTY]) RETURN COUNTROWS(T1)-COUNTROWS(FILTER(T1,[sum]<>0)) I want to edit this formula to include ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi learner03 

     

    Try it

    Count = 
VAR T1=ADDCOLUMNS(VALUES(ULDs[Location]),"sum",[SUM TOTAL QTY])
RETURN
COUNTROWS(FILTER(T1,[sum]<>0 || ISBLANK([sum]))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi learner03 

 

Try it

Count = 
VAR T1=ADDCOLUMNS(VALUES(ULDs[Location]),"sum",[SUM TOTAL QTY])
RETURN
COUNTROWS(FILTER(T1,[sum]<>0 || ISBLANK([sum]))