Forum Discussion

DJSwezey's avatar
DJSwezey
Icon for Helper I rankHelper I
3 years ago

Sort order breaks running total measure!!

I have a simple sales table below: 'Sales'     This thrown into a simple Matrix looks like this:   My objective is to move the TOTALs to the front of the matrix (left) and then to cr...
Help
needs help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Try this version

 

Goal Running Total = 
var mx = MAX('Week Order'[Week Of])
return CALCULATE( sum(Sales[Goal]),'Week Order'[Week Of] <= mx)