Forum Discussion
NewbieJono
Post Partisan
Post PartisanFilter to show max date value only
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")
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))
1 Reply
- amitchandak
Super User
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))