Return Value based on max date

[NewbieJono]

Hello, i am trying to return the volume (marked in yellow) 0.906. it does not seem to be working, I think its something to do with the max date criteria.

i would like to return the latest (max date) for Measure 1, Baseline

I have tried 

Test = 
CALCULATE (
    SUM ( 'DIM - Targets'[Volume] ),
    'DIM - Targets'[Measure] = "Measure1",
    'DIM - Targets'[Type] = "Baseline",
    LASTDATE ( 'DIM - Targets'[Date] )
)

[amitchandak · Accepted solution]

@NewbieJono , try measure like

Last Status = var _max = maxx(filter(ALLSELECTED('DIM - Targets'), 'DIM - Targets'[Measure] = "Measure1" && 'DIM - Targets'[Type] = "Baseline"), 'DIM - Targets'[Date] )
return
CALCULATE(sum( 'DIM - Targets'[Volume] ), filter(('DIM - Targets') , 'DIM - Targets'[Date] =_max))

Latest Date Date | Latest Data
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...