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.