Forum Discussion

Rsanjuan's avatar
Rsanjuan
Icon for Advocate III rankAdvocate III
9 years ago
Solved

Calculate and ignoring null value

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...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Please try this measure

     

     

    Measure = CALCULATE(
				SUM(Table1[Column B]),
				'Table1'[Column A]<> BLANK()
				)
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Please try this measure

 

 

Measure = CALCULATE(
				SUM(Table1[Column B]),
				'Table1'[Column A]<> BLANK()
				)
  • Dean1972's avatar
    Dean1972
    Frequent Visitor
    8 years ago

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