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 BLANK rows as well in the last part of formula where it is COUNTROWS(T1)-COUNTROWS(FILTER(T1,[sum]<>0)).
 
Anonymous 
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]))

2 Replies

  • 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]))