COUNT formula to include BLANK

[learner03]

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)).

@Vera_33 

[Vera_33 · Accepted solution]

Hi @learner03 

Try it

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

[ryan_mayu]

@learner03 

could you pls provide the sample data and expected output?