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