Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@Anonymous
Is this what you want?
rownumber = CALCULATE(COUNTROWS(Sheet12),FILTER(Sheet12,Sheet12[quantity number]<0))
Proud to be a Super User!
@Anonymous
Is this what you want?
rownumber = CALCULATE(COUNTROWS(Sheet12),FILTER(Sheet12,Sheet12[quantity number]<0))
Proud to be a Super User!
Yes, thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |