Calculate and ignoring null value

[Rsanjuan]

What is the correct syntax for calculating the sum of a column only if another column is not null? For example,

I would only want to calculate the numbers in the second column, where Column A is not null.

Thanks!

[Phil_Seamark · Accepted solution]

Please try this measure

Measure = CALCULATE(
				SUM(Table1[Column B]),
				'Table1'[Column A]<> BLANK()
				)

[Dean1972]

How would you write the measure if you have various date columns that return "null"
Table = PRJ
Columns = Billing, Due, etc