Forum Discussion

YPBI's avatar
YPBI
Frequent Visitor
2 years ago

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...
Need Help
YPBI's avatar
YPBI
Frequent Visitor
2 years ago

Thanks for the responses, however the end result needs to look like this:

 

The running total should cumulatively sum each percentage in the % Scaled Score column.

 

Ashish_Mathur Dangar332 parry2k 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    That is exactly what my solution does.

    • YPBI's avatar
      YPBI
      Frequent Visitor
      2 years ago

      Hi -

       

      I think the problem is that the SS measure you've created is a sum. It needs to be a count, as the Count of Scaled Scores column is basically the number of students who fell within that grouping. I changed the SUM to COUNT but then the Running total SS measure doesn't work...