Sum values if another column is not blank

[polman4]

Hello,

I'm relatively new to dax and i'm trying something more complicated but i fail 😞

I have the following data:

	Product	Available	Sold
1	Product_1	10	9
2	Product_1	66	0
3	Product_1	45	38
4	Product_2	48	0
5	Product_2	41	0
6	Product_3	54	29
7	Product_3	45	27
8	Product_3	17	0
9	Product_3	15	9

What i would like to do is:

Check if there any value in column sold greater than zero.

If yes then sum all 'available' by product.

Product	Available (sum)
Product_1	121 (10+66+45)
Product_2	0 or null
Product_3	131 (29 + 27 +10 +9)

I tried the following

sumif = 
    var __table = 
        FILTER('data$',
        [Sold] <> 0
)
return
sumx(__table,[Available])

but i only get the sum of the rows that are non zero (rows: 1, 3, 6, 7 and 9)

What i'm missing?

Thank you!

Grigoris

[polman4]

Thank you! Works great

[tamerj1 · Accepted solution]

Hi @polman4 

please use

sumif =
IF ( SUM ( 'data$'[Sold] ) > 0, SUM ( 'data$'[Available] ) )