Cumulative total of a constant

[MichaelF1]

Hey everyone,

This looks like it should be a simple problem, but I'm struggling with it!

How do I calculate a cumulative total of a constant value?

So in the table below, I have created a constant  measure, MY NUMBER and in the Running NUMBER column I want it to show: 13, 26,39,52.

This is what I've tried :

Running NUMBER = CALCULATE([MY NUMBER], FILTER(ALL('Date Table'[YearWeek]), 'Date Table'[YearWeek]<MAX('Date Table'[YearWeek])))

But it just returns the MY NUMBER again, as you can see.

Thanks in advance! 🙂

[SpartaBI]

@MichaelF1 Are you sorting the week by another column?
Also can you check one sec and remove the my number column / measure from the table and tell me what you get

[MichaelF1]

Hi @SpartaBI , thanks for the quick response!

I'm not sorting by any other column.

This is what I get when I remove the Running NUMBER column:

[SpartaBI]

@MichaelF1 can you PM me to do a quick zoom call?

[SpartaBI · Accepted solution]

@MichaelF1 

Running_Target =
VAR _current_week = SELECTEDVALUE('Date Table'[YearWeek])
VAR _weekly_target = [Weekly Target 4wk]
VAR _tbl = 
	ADDCOLUMNS(
		ALLSELECTED('Date Table'[YearWeek]),
		"@Target", _weekly_target
	)
VAR _result = 
	SUMX(
		FILTER(
			_tbl,
			'Date Table'[YearWeek] <= _current_week
		),
		[@Target]
	)

RETURN
	_result

      

Showcase Report – Contoso By SpartaBI