Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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")
Solved! Go to 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))
@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))