Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running filter to sort by measure

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.

  • Hi Anonymous ,

     

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

     

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

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