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 so...
Need Help
MattAllington's avatar
MattAllington
Community Champion
10 years ago

I just provided you a solution that works for the sample data you posted. If your data is not like the sample data you posted, then it won't work - of course.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

no MattAllington,

it didn't workout for my sample data.

please consider the following screenshot.

All Measures

Here   

1.                     Contr = DIVIDE(SUM(Query1[Revenue]),[Total Revenue],0) 

where  Total Revenue = CALCULATE(SUM(Query1[Revenue]),ALL(Query1))

and the formula you suggested

                              RT = CALCULATE([Contr],FILTER(ALL(Query1),Query1[ItemNumber] <= MAX(Query1[ItemNumber]))) 

2.. Contribution   = SQL generated (Revenue / sum(Revenue) ) from SQL Source

    Running Total = MAXX(Query1,CALCULATE(SUM(Query1[Contribution]),Query1[Contribution] >= EARLIER(Query1[Contribution]),ALL(Query1))) 

 

in which 2 is working fine .But i dont want to calculate Contribution at SQL level.