Forum Discussion

ns29's avatar
ns29
Icon for Helper I rankHelper 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's avatar
    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] )
    )
)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
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] )
    )
)

 

ns29's avatar
ns29
Icon for Helper I rankHelper I
6 years ago

Thank you for the elegant solution!