Forum Discussion

jetsger's avatar
jetsger
New Member
2 years ago
Solved

Running Total with Multiple Parameters

I've tried a few of the standard methods for running totals, though I have multiple pieces of data on the same date that I need to account for individually - 

 

The following did not work, nor did the creation of an index to accomplish a similar goal

SOY running total in Arrival =
CALCULATE(
    SUM('Full Data'[X]),
    FILTER(
        ALLSELECTED('Full Data'[Arrival]),
        ISONORAFTER('Full Data'[Arrival], MAX('Full Data'[Arrival]), DESC)
    )
)
 
Id like to be able to see a running total for the following matrix where after each vessel listed, a running total would sum the 3 columns of data and add to the prior row.

 

IE a column in row 1 would read 30,000, row 2 would read 60,000, row 3 would read 90,000, row 4 would read 

 

Not sure if i am able or how to adjust the formula to appropriately see a running total that would reset with each change in port.

 

Thank you!

Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi jetsger - Create a below measure that will calculate a running total that resets for each port.

    Running Total =
    VAR CurrentPort = MAX('Full Data'[Port])
    VAR CurrentArrival = MAX('Full Data'[Arrival])
    VAR CurrentVessel = MAX('Full Data'[Vessel])
    RETURN
    CALCULATE(
    SUM('Full Data'[DataColumn1]) + SUM('Full Data'[DataColumn2]) + SUM('Full Data'[DataColumn3]),
    FILTER(
    ALL('Full Data'),
    'Full Data'[Port] = CurrentPort &&
    'Full Data'[Arrival] <= CurrentArrival &&
    'Full Data'[Vessel] <= CurrentVessel
    )
    )

     

    Hope it helps

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi jetsger - Create a below measure that will calculate a running total that resets for each port.

    Running Total =
    VAR CurrentPort = MAX('Full Data'[Port])
    VAR CurrentArrival = MAX('Full Data'[Arrival])
    VAR CurrentVessel = MAX('Full Data'[Vessel])
    RETURN
    CALCULATE(
    SUM('Full Data'[DataColumn1]) + SUM('Full Data'[DataColumn2]) + SUM('Full Data'[DataColumn3]),
    FILTER(
    ALL('Full Data'),
    'Full Data'[Port] = CurrentPort &&
    'Full Data'[Arrival] <= CurrentArrival &&
    'Full Data'[Vessel] <= CurrentVessel
    )
    )

     

    Hope it helps