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?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler 
I tried changing the running total measure to 

OPs Ship Fcst running total in Fiscal Week =
CALCULATE(
    [Shipment Forecast],
    FILTER(
        ALLSELECTED('Fiscal Calendar'[Fiscal Week]),
        ISONORAFTER('Fiscal Calendar'[Fiscal Week], MAX('Fiscal Calendar'[Fiscal Week]), DESC)
    )
)

But the visual looks the same. In addition when drilling down by calendar date, it no longer shows the running total.