Cumulative Total by Index

Hi CoreyP ,

This is a context problem, when you add the measure in your table since you have other columns within the visual and all of the fields belong to the same table the context changes so you need to apply the filter no only to the INDEX column but to all other columns in this case you need to redo your measure to:

Cumulative =
CALCULATE (
    SUM ( 'Pick sequence'[ONHAND_QTY] );
    FILTER (
        ALLSELECTED (
            'Pick sequence'[Pick Sequence];
            'Pick sequence'[PALLET_ID];
            'Pick sequence'[Item N.º]
        );
        'Pick sequence'[Pick Sequence] <= MAX ( 'Pick sequence'[Pick Sequence] )
    )
)

Check PBIX file attach I added a slicer for pallet s you can try to select different values and check that the cumulative still is calculated.