Wrong total when combining two measures based on IF condition

[ellac]

Hi!

I'm trying to combine to measures - Measure 1 & Measure 2 - based on what date it is. This is Measure 3. I want to show Measure 1's value for the days up until today, and Measure 2's value for today and forward. My current solution gives med the wrong total.

My DAX code right now: 

Measure 3=
IF(
    MAX([DATE]) < TODAY(),
    [MEASURE 1],

    [MEASURE 2]
)

As you can see I get the same total for Measure 3 as Measure 2. It should be 51, not 76.

FYI, I only have data in my columns to create Measure 1 and Measure 2 as they are in the picture.

Any ideas on what to do?

/Ella

[Jos_Woolley]

You're welcome!

Cheers

[Jos_Woolley · Accepted solution]

Hi,

MyMeasure :=
VAR MyTable =
    SUMMARIZE(
        'Table',
        'Table'[DATE],
        "Value", IF( 'Table'[DATE] < TODAY(), [MEASURE 1], [MEASURE 2] )
    )
RETURN
    IF(
        ISFILTERED( 'Table'[DATE] ),
        IF( MAX( 'Table'[DATE] ) < TODAY(), [MEASURE 1], [MEASURE 2] ),
        SUMX( MyTable, [Value] )
    )

Regards

[ellac]

Hi Jos! IT IS WORKING 🙂 Thank you so much for such a quick response!!