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

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()))

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Please find attached the PBI file.

Hope this helps.