cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joohnmark12 Regular Visitor
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 Smiley Sad. Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
ryan_mayu Established Member
Established Member

Re: Count rows with condition

@joohnmark12

 

 

Is this what you want?

 

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

c1.JPGc2.JPG

2 REPLIES 2
ryan_mayu Established Member
Established Member

Re: Count rows with condition

@joohnmark12

 

 

Is this what you want?

 

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

c1.JPGc2.JPG

joohnmark12 Regular Visitor
Regular Visitor

Re: Count rows with condition

Yes, thank you very much!