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
parry2k's avatar
parry2k
Super User
2 years ago

YPBI you can try something like this:

 

RT Measure = 
CALCUALTE ( 
    [Existing Measure], 
    FILTER ( 
          ALL ( 'Grouping Table' ), 
          'Grouping Table'[Id] <= MAX ( 'Grouping Table'[Id] ) 
    )
)
  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    2 years ago

    YPBI listen to parry2k.  He's one of the best Super Users and has helped me numerous times!  ğŸ™‚

  • YPBI's avatar
    YPBI
    Frequent Visitor
    2 years ago

    That doesn't seem to get me the desired result.

     

     

    RT Measure = 
CALCULATE(  
    [% Scaled Scores], 
    FILTER ( 
          ALL ( TestData[Sort SS Grouping]), 
          'TestData'[Sort SS Grouping] <= MAX ( TestData[Sort SS Grouping])

     

     

     

    I tried swapping the Sort SS Grouping with Scaled Scores Grouping and got this...first two rows sum correctly