Running Total for % Calculation

[Qazafi]

Hi There

I would like to Calculate Running Total for my percentage Measure. I have a scenario where I have calculated the % of a Measure and I need to calculate running total for that % column to display it in my line graph. Can some one please take a look on the attached screenshot and advise me This is how I calculated my % Measure

% of Total Valuations = DIVIDE ( [Number of Valuation], CALCULATE ( [Number of Valuation], ALLSELECTED (), VALUES ( 'Date'[Financial Year] ) ) )

Running total of % Measure

[v-shex-msft]

HI @Qazafi,

For your requirement, I think you need index column to let the measure formula can calculate loop all records, without index column is impossible calculate the running percent.

In addition, if you share some sample file, i think it will be help for clarity your scenario and write formula.

Regards,

Xiaoxin Sheng