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

Hi,

Share the download link of the PBI file.

YPBI's avatar
YPBI
Frequent Visitor
2 years ago

Would love to share but the dataset contains all sorts of sensitive information...

 

These are the relevant columns at play though:

 

 

% Scaled Scores measure:

 

% Scaled Scores = 
DIVIDE(
    COUNT(TestData[Scaled Score]),
        CALCULATE(
            COUNT(TestData[Scaled Score]),ALLSELECTED()))

 

    • 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.