Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Running Total for % Calculation

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    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