cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PhoenixBird66 Frequent Visitor
Frequent Visitor

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

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])

 

Capture.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
AkhilAshok Established Member
Established Member

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

Try:

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

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

Hi @PhoenixBird66 ,

 

Try using this measure:

 

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

Regards,

 

Fernando

AkhilAshok Established Member
Established Member

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

Try:

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

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

That works, thanks so much for your help!