Forum Discussion
Running Total
I wrote a blog post today about how to create a Pareto Cumulative Running Total
http://exceleratorbi.com.au/cumulative-running-total-based-on-highest-value/
Are you writing a measure or a calculated column?
What defines the order of the running total? Do you have an ID column in your data table, or a date column or something?
Do you have a calendar table?
How are you planning on visualising this? In a Pivot table with some ID column on rows and the running total in values?
Everything is a Measure.
And Revenue is a Default measure from Fact.
I want output like this.
After descending order of Contribution I will calculate Running Total.
Item Revenue Contribution RunningTotal
1 300 0.50 0.50
2 200 0.33 0.83
3 100 0.16 0.99
=calculate([contribution],filter (all(table),table[item] <=max(table[item])))
Negative MattAllington..!!
how can we use '<= max(item)' condition, when Items are sorted in desccending order of contribution...??
what if I dont have Item Number and want to use Item Name from dimension, this max() function shouldn't work with strings as far as i know.