Sum values if another column is not blank

polman4 — Mon, 20 Jun 2022 12:08:18 GMT

Hello,

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

I have the following data:

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.

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

Re: Sum values if another column is not blank

tamerj1 — Mon, 20 Jun 2022 12:30:36 GMT

please use

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

polman4 — Tue, 21 Jun 2022 15:58:25 GMT

Thank you! Works great