Add back another measure if the current measure returns a blank

[WhaleWatcher222]

Hi Expert

See table below if column A has a Value and Column B is blank then see result column likewise of column A is Blank and Column B has a Value see results column... 

Column A	Column B	Result
2		2
2		2
	5	5
3		3
3		3

I am trying to do this with my measure but the measure gives me either or..

Result = 
VAR _AddbackActuals = CALCULATE(SUM('F Datasets'[Amount]), FILTER('F Datasets','F Datasets'[Forecasts-Actuals] = "A"),
    REMOVEFILTERS('F Datasets'[Dataset]),
    REMOVEFILTERS('F Datasets'[Budget Name])
)
RETURN
    if(_AddbackActuals = Blank(), [Total F])

Where _AddbackActuals are the Values in Column A and [Total F] should be the values in column B 

[danextian · Accepted solution]

I am not exactly sure what you're trying to achieve but you could use COALESCE to return the first non-blank value among a list of values. Example:

COALESCE ( [columnA measure], [columnB measure] )

[PijushRoy]

Hi @WhaleWatcher222 

Please try this DAX

Result = 
VAR _AddbackActuals = CALCULATE(SUM('F Datasets'[Amount]), FILTER('F Datasets','F Datasets'[Forecasts-Actuals] = "A"),
    REMOVEFILTERS('F Datasets'[Dataset]),
    REMOVEFILTERS('F Datasets'[Budget Name])
)
RETURN
    If(ISBLANK(_AddbackActuals),[Total F],_AddbackActuals)

[audreygerred]

Hi! Here is the measure I created to test it out and appears to be working:

DynamicSum =

IF(

    ISBLANK(SUM([Column B])),

    SUM([Column A]),

    IF(

        ISBLANK(SUM([Column A])),

        SUM([Column B]),

        BLANK()

    )

)

If you need the result (dynamic sum) measue to also sum the values, you can use this instead:

DynamicSum2 =

SUMX(

    'Table',

    IF(

        ISBLANK('Table'[Column B]),

        'Table'[Column A],

        IF(

            ISBLANK('Table'[Column A]),

            'Table'[Column B],

            'Table'[Column A] + 'Table'[Column B]

        )

    )

)