cancel
Showing results for
Did you mean:
Regular Visitor

## 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!

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: Count rows with condition

@joohnmark12

Is this what you want?

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

2 REPLIES 2
Established Member

## Re: Count rows with condition

@joohnmark12

Is this what you want?

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

Regular Visitor

## Re: Count rows with condition

Yes, thank you very much!