DAX measure help - return a value from one column if the value in another column is not blank

[PhoenixBird66]

I'm trying to create a measure which returns the value from the January 2019 Revenue column, if the value in the Jan%Increase_Excluding Outliers column is not blank.

I've tried this DAX measure but it doesn’t work correctly - the total at the bottom looks wrong (it’s the same as the total for January 2019 Revenue, and I think it should be less because I want it to ignore some of the sales):

Measure 3 = IF( NOT( ISBLANK( [Jan%Increase_Excluding Outliers] ) ) , [January 2019 Revenue])

[AkhilAshok · Accepted solution]

Try:

Measure 3 =
SUMX (
    VALUES ( Table[StdSvcKey] ),
    IF (
        NOT ( ISBLANK ( [Jan%Increase_Excluding Outliers] ) ),
        [January 2019 Revenue]
    )
)

[PhoenixBird66]

That works, thanks so much for your help!

[calerof]

Hi @PhoenixBird66 ,

Try using this measure:

Measure 3 = CALCULATE(
                SUM( Table1[Jan 2019 Revenue] ),
                FILTER( Table1, Table1[Jan% Increase excl outl] <> BLANK() )
)

Regards,

Fernando