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.
Product stock
Tomato 7899
Orange 43
Banana -90
Spinach 89
I want to create a measure to find products where the stock level is negative. I am using the following code but not working.
Total Stock = sumx(Inventory,Inventory[stock])
Short Products = if([Total Stock]<0,Inventory[Product],Blank())
Can anyone help me with this please? I can create a new column in Inventory table but I dont want to do that as it consumes more momory. How can I achieve this using DAX code?
Solved! Go to Solution.
Measure = IF(SUM('Table'[Stock Value])>=0,BLANK(),1)
OR
Measure = IF(SUM('Table'[Stock Value])>=0,BLANK(),1)
OR
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |