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...

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous What happens if you base your running total on Fiscal Week instead of the Date?