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, s...
Anonymous
Is this what you want?
rownumber = CALCULATE(COUNTROWS(Sheet12),FILTER(Sheet12,Sheet12[quantity number]<0))
Anonymous
Is this what you want?
rownumber = CALCULATE(COUNTROWS(Sheet12),FILTER(Sheet12,Sheet12[quantity number]<0))
Yes, thank you very much!