Forum Discussion
Count rows with condition
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!
Anonymous
Is this what you want?
rownumber = CALCULATE(COUNTROWS(Sheet12),FILTER(Sheet12,Sheet12[quantity number]<0))
2 Replies
Anonymous
Is this what you want?
rownumber = CALCULATE(COUNTROWS(Sheet12),FILTER(Sheet12,Sheet12[quantity number]<0))