Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] ) ) )
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |