Forum Discussion
Running Total
Hello All,
Please help me with this.
Revenue is a Default meausre from SQL server source.
I calulated Revenue Contribution(Measure) as DIVIDE(SUM(Query1[Revenue]),[Total Revenue],0)
then after sorting the Contribution I tried calculating another Measure as follows but earlier is not suppose to show 'Contribution' measure while i am typing
MAXX(Query1,CALCULATE([Contribution],[Contribution] >= EARLIER("I want Contribution Measure here"),ALL(Query1)))
for running total (the calculation i got from this post )
But this is possible with Revenue which is a default Measure from source.
MAXX(Query1,CALCULATE(SUM(Quer1[Revenue]),Quer1[Revenue] >= EARLIER(Query1[Revenue]),ALL(Query1)))
Is there any way to pass 'Contribution' as argument to 'Erliler' function
or Calculating Contribution at sequel level and bringing it as a default measure as revenue is only the way.
I dont want to
Thanks in advance.
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/
20 Replies
- MattAllingtonCommunity Champion
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?
- AnonymousNot applicable
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
- MattAllingtonCommunity Champion
=calculate([contribution],filter (all(table),table[item] <=max(table[item])))