Conditional Measure to add 1 column if another column is not null

[priley9406]

Hi,

I'm trying to add the Estimated Customer Locations column if the Da Complete Date is not null.

This is what I'm using, but getting no results.

Completed Locations = SUMX('2022 IFP Build',IF(CALCULATE(SUM('2022 IFP Build'[Estimated Customer Locations]),'2022 IFP Build'[DA Complete Date]<>"null")>0, IF('2022 IFP Build'[DA Complete Date] = "null",0)))

Estimated Customer Locations	DA Date	DA Complete Date
350	02202021	06202021
255	04202021
25	03202021	07012021

[v-yalanwu-msft]

Hi, @priley9406 ;

You could modify the measure as follows:

Completed Locations = 
SUMX (
    '2022 IFP Build',
    IF (
        CALCULATE (
            SUM ( '2022 IFP Build'[Estimated Customer Locations] ),
            '2022 IFP Build'[DA Complete Date] <> BLANK()
        ) > 0,
      SUM([Estimated Customer Locations]),0
    )
)

Or

Completed Locations2 = IF(MAX([DA Complete Date])=BLANK(),0,MAX([Estimated Customer Locations]))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix · Accepted solution]

Hi @priley9406 ,

Don't know if this is a measure or a calculate column however the word "null" will not work on this because this is dax and that is not recognized.

What you should use instead of "null" is the BLANK() or the "".

In this case you should redo your measure to:

Completed Locations =
SUMX (
    '2022 IFP Build',
    IF (
        CALCULATE (
            SUM ( '2022 IFP Build'[Estimated Customer Locations] ),
            '2022 IFP Build'[DA Complete Date] <> BLANK ()
        ) > 0,
        IF ( '2022 IFP Build'[DA Complete Date] = BLANK (), 0 )
    )
)