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!
Solved! Go to Solution.