Count rows with condition

[Anonymous]

Hello guys, I'm newbie to PowerBI and I need some logical help. 

I've a table named Sheet1 with a colunm named Stock Quantity. Basically I want to count the rows that has negative stock number, so in order to organize I created a calculated column "Flag N" that represents if the current row is negative or positive. So I tried making this IF(Sheet1[Flag N] = "N";Count(Sheet1[Stock Quantity]; 0), I know its wrong but I don't have any clue of what can I do, please help me :(. Thanks! 

[ryan_mayu · Accepted solution]

@Anonymous

Is this what you want?

rownumber = CALCULATE(COUNTROWS(Sheet12),FILTER(Sheet12,Sheet12[quantity number]<0))

[Anonymous]

Yes, thank you very much!