Forum Discussion
Anonymous
6 years agoNot applicable
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
Community Support
Hi Anonymous ,
We can make the table visual sorted by your measure like this.