Forum Discussion
Cumulative sum issue
Hi All,
I am facing few issues in cumulative sum:
Below is my fact table and i have created a calender dimension table for the same as below :
Fact:
| ID | BA_ID | Amount | Date |
| 1 | 1 | 10 | 10/10/2010 |
| 2 | 1 | 20 | 10/11/2010 |
| 3 | 1 | 30 | 10/11/2010 |
| 4 | 1 | 40 | 10/13/2010 |
| 5 | 1 | 50 | 10/14/2010 |
| 6 | 1 | 60 | 10/11/2010 |
| 7 | 2 | 70 | 10/16/2010 |
| 8 | 2 | 80 | 10/17/2010 |
| 9 | 2 | 90 | 10/11/2010 |
| 10 | 2 | 100 | 10/19/2010 |
| 11 | 2 | 110 | 10/20/2010 |
| 12 | 2 | 120 | 10/21/2010 |
| 13 | 2 | 130 | 10/22/2010 |
| 14 | 2 | 140 | 10/23/2010 |
| 15 | 3 | 150 | 10/24/2010 |
| Date |
| 10/5/2010 |
| 10/6/2010 |
| 10/7/2010 |
| 10/8/2010 |
| 10/9/2010 |
| 10/10/2010 |
| 10/11/2010 |
| 10/12/2010 |
| 10/13/2010 |
| 10/14/2010 |
| 10/15/2010 |
| 10/16/2010 |
| 10/17/2010 |
| 10/18/2010 |
| 10/19/2010 |
| 10/20/2010 |
| 10/21/2010 |
| 10/22/2010 |
| 10/23/2010 |
| 10/24/2010 |
I have created a sum measure : total Amount = sum(fact(amount))
Then i am creating another measure for putting it on trend chart :
Trend Sum = Calculate ([Total AMount],Filter (All(fact),fact(ba_id)=1),
Filter (values(date),date(date)<=max(date[date])))
this is not giving me cumulative sum.
