Countrows where 0 OR BLANK/NULL

[learner03]

I want to count the rows where the Sum of lines if 0 OR Blank.

I have written this below function for 0 but cannot get how to write function that says OR blank/ Null.

Count = CALCULATE(COUNTROWS(DISTINCT(ULDs[Location])),FILTER(ULDs,(ULDs[SUM TOTAL QTY]=0)))

[Vera_33 · Accepted solution]

Hi @learner03 

Is your [SUM TOTAL QTY] a measure? you can do it, the performance is better

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

[learner03]

This is perfect. 

Thank you so much. I wish I had this skill level 🙂