Forum Discussion
Running Total % on Measure
Hi - I want to create running total column based on the values in the % Scaled Scores column. The probem is that the said column is a measure, so solutions that use SUM won't work. What would the DAX...
hi, YPBI
try below measure
adjust your table name
result =
var a = CALCULATE(SUM('Table'[scaled score]),KEEPFILTERS('Table'[sort ss grouping]<=MAX('Table'[sort ss grouping])),REMOVEFILTERS('Table'[scaled scores grouping]))
var b = CALCULATE(SUM('Table'[scaled score]),REMOVEFILTERS('Table'[scaled scores grouping]))
return
DIVIDE(a,b)
and YAH! here you use highest sort ss grouping value for low range of scaled scores grouping so you get desc answer