Running filter to sort by measure

[Anonymous]

I am trying to calculate a running total for each row of a table, but I want the sorting for accumulation to be based on a measure. The reason I can't change this measure to a column is that it is a ranking measure based on a what-if parameters, which cannot be used to calculate columns.

Below is the DAX function I am using for the running total:

Spend running total =
VAR Score =
    CALCULATE ( SUM ( Table2[Scoring_Measure] ) )
RETURN
    CALCULATE (
        SUM ( Table2[Amount] ),
        FILTER (
            ALL ( Table2[Scoring_Measure] ),
            CALCULATE ( SUM ( Table2[Scoring_Measure] ) >= Score )
        )
    )

Thanks for your help.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ，

We can make the table visual sorted by your measure like this.