topic Re: Wrong total when combining two measures based on IF condition in DAX Commands and Tips

Wrong total when combining two measures based on IF condition

Anonymous — Tue, 22 Feb 2022 09:09:27 GMT

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

Re: Wrong total when combining two measures based on IF condition

Jos_Woolley — Tue, 22 Feb 2022 09:41:56 GMT

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

Re: Wrong total when combining two measures based on IF condition

Anonymous — Tue, 22 Feb 2022 09:50:46 GMT

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

Re: Wrong total when combining two measures based on IF condition

Jos_Woolley — Tue, 22 Feb 2022 10:09:55 GMT

You're welcome!

Cheers