Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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.

20 Replies

  • MattAllington's avatar
    MattAllington
    Community 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?  

    • Anonymous's avatar
      Anonymous
      Not 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

      • MattAllington's avatar
        MattAllington
        Community Champion

        =calculate([contribution],filter (all(table),table[item] <=max(table[item])))