Cumulative sum issue

[Anonymous]

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.

[amitchandak]

Refer

https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115

[Anonymous · Accepted solution]

Hi,

All function does not fetch correct result in SSAS tabular modelling, i replaced Values with Allselected and it worked.

Thanks for the help 🙂