Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Running Total Measure Works By Day but Not by Week

Hello,   I am having a problem with displaying the running total of a column in a Line and Stacked Column Chart visual. This visual is to show forecasted and actual shipping numbers. The X axis h...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Edited:

     

    [The Right Measure] =
var MaxFiscalDate = MAX( 'Fiscal Calendar'[Calendar Date] )
var Result =
	CALCULATE(
	    [Shipment Forecast],
	    KEEPFILTERS( 'Fiscal Calendar'[Calendar Date] <= MaxFiscalDate ),
	    ALLSELECTED( 'Fiscal Calendar' )
	)
return
	Result

     

     

    There would be too much to explain about how ALLSELECTED works...

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous After fixing my model, the issue was resolved. However I noticed that that when I select multiple options in any slicer, the running total resets after that time interval. With one selected or none in each slicer, there are no issues. In the example below, I have weeks 1-5 selected.

 

The Total Shipped (Blue) and Shipment Forecast (Green) follow the format of your measure above. Any idea on why this is happening?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Instead of going back and forth aimlessly and fruitlessly... please place a link to the file in here. I'll then resolve all the issues you have. Promise.