cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Qazafi
Frequent Visitor

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 % MeasureRunning total of % Measure

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors