Forum Discussion

Helper I

6 years ago

Solved

Running Total - looking for a more elegant solution

I'm looking for a more elegant solution to set up a Total Run on the selected items. See the attached screenshot and sample file at the following link. In the sample file, on the running_total tab, y...

Need Help

Tips and Tricks

danextian

6 years ago

Hi ns29 ,

Try this:

RunningTotal = 
CALCULATE (
    SUM ( Table1[performance] ),
    FILTER (
        FILTER ( ALL ( Table1[age] ), Table1[age] >= 2 ),
        Table1[age] <= MAX ( Table1[age] )
    )
)

v-gizhi-msft

Community Support

6 years ago

Hi,

Please try to create a What If parameter:

Parameter = GENERATESERIES(1, 24, 1)

Then try this measure:

performance_running_total_selected = 
CALCULATE(
	SUM('Table1'[performance]),
	FILTER(
		ALL('Table1'[age]),
		ISONORAFTER(IF([age]<=SELECTEDVALUE(Parameter[Parameter])-1,1000,[age]), MAX([age]), DESC)
	)
)

If you want to start from 2, when select '2' in parameter slicer, the result shows: