Retrieve the max value

[BiBra]

Hello

I want to retrieve two things: value at recent date, and the date, where the value was at the highest. I have achieved the first by a measure. However, when I try to retrieve the date with max value, I am unable to do so.  The following is the code that works: 

Value at recent date = 
CALCULATE(
SUM('inStock'[Value]);
FILTER('inStock';'inStock'[DateFirstSaved] = MAX('inStock'[DateFirstSaved])))

The following is what does not work:

Max value = 
CALCULATE(
SUM('inStock'[Value]);
FILTER('inStock';'inStock'[DateFirstSaved] = MAX('inStock'[Value])))

Can anyone help me achieve this?

[Zubair_Muhammad]

@BiBra

Please try this

Max value =
VAR myvalue = [Value at recent date]
RETURN
    CALCULATE (
        FIRSTNONBLANK ( 'inStock'[DateFirstSaved], 1 ),
        FILTER (
            ALLSELECTED ( 'inStock'[DateFirstSaved] ),
            CALCULATE ( SUM ( inStock[Value] ) ) = myvalue
        )
    )

[BiBra]

I am trying it out right now. However I experienced, that it will not accept 1 in FIRSTNONBLANK.

[Zubair_Muhammad]

@BiBra

It should. Even you could out 0, TRUE()

Could you share the screen shot?

[BiBra]

[Zubair_Muhammad]

HI @BiBra

Replace

FIRSTNONBLANK ( 'inStock'[DateFirstSaved], 1 )

With

Values('inStock'[DateFirstSaved])

or

MAX('inStock'[DateFirstSaved])

[BiBra]

No errors in the code now. However it cannot display

[v-shex-msft]

Hi @BiBra,

Please share some sample data and pbix file for further test.

Regards,

Xiaoxin Sheng

[Zubair_Muhammad]

@BiBra

or replace the comma with

FIRSTNONBLANK ( 'inStock'[DateFirstSaved]; 1 )