Need Help with a DAX CALCULATE Formula - it is returning wrong row count

[TPearson]

I am attempting to count my orders in process.  I am using the below CALCULATE formula.  When I manually go to the Facts table and filter the columns as outlined below, I get an entirely different row count than what this formula is returning.  Does anyone know why?

Manual Filters applied: Status ID =3 AND CloseOutDate = BLANK   (returns 42 rows)

Below formula returns 9 rows in my visual.

InProcessCnt = CALCULATE(COUNTROWS(Facts), FILTER(Facts, Facts[status_id] = 3 && Facts[CloseOutDate] = BLANK()) )

I am a novice, mostly self taught, and an ops person - so the simpler the better please! 

[dedelman_clng]

Also in the meantime you can try

InProcessCnt = CALCULATE( COUNTROWS(Facts), Facts[status_id] = 3, Facts[CloseOutDate] = BLANK() ) 

(the FILTER is extraneous when using CALCULATE and not filtering on MIN/MAX etc)

David

[dedelman_clng]

Hi @TPearson - how are you displaying InProcessCnt ?  Sounds like there might be other filters in play. Can you share copy of your pbix with sensitive data removed (link from OneDrive, DropBox, Github, Google Drive, etc)

David