Filter to show max date value only

[NewbieJono]

Hello, My volume field next to sparkline is summing all the voloumes, is there a way to only show the max filtered date volume?

current dax

VolumeTest = CALCULATE(SUM('FACT - Volumes'[Total Volume]),'DIM - COO Mapping'[Group ]="ISG")

[amitchandak · Accepted solution]

@NewbieJono , Try a measure like

VolumeTest =
var _max = maxx(allselected('Date'), 'Date'[Date])
return
CALCULATE(SUM('FACT - Volumes'[Total Volume]),filter('DIM - COO Mapping','DIM - COO Mapping'[Group ]="ISG"), Filter('Date', 'Date'[Date] =_max))