Cumulative total Column with dynamic ranking Column

Hi, Anonymous 
Try this:

RunningTotal =
VAR _currank2Table =
    ADDCOLUMNS ( 'MAESTRO V2 - Tesson''s Curve', "_Ranking Ter", [Ranking Ter] )
RETURN
    SUMX (
        FILTER ( ALL ( _currank2Table ), [_Ranking Ter] < [Ranking Ter] ),
        [TO ]
    )

 If this does not work, for a quick fix, consider sharing the dummy sample data and expected output.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, Anonymous 

Try this:

_RunningTotal CST = 
//***********************************************************************************************************
// solution: only need one measure
VAR _CURRENT_perNM=MAX('Tesson''s Curve'[NM%])
VAR _sumx=SUMX(FILTER(ALLSELECTED('Tesson''s Curve'),'Tesson''s Curve'[NM%]>=_CURRENT_perNM),[TO ])

return _sumx

Result:

If it's just to get cumulative totals, you only need this one measure.
But you can use the ranked column sorting table, which, by the way, I recreated to be a more concise ranking measure hopefully useful to you.

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.