Calculation of Cumulative values based on the selected date and category

[Anshenterprices]

Hi Team,

Date	Category	Value
10/18/6061	Equity	0.060695565
10/15/6061	Equity	0.06615055
10/16/6061	Equity	0.515556657
10/15/6061	Equity	-0.06055155
10/16/6061	Equity	-0.66555696
10/11/6061	Equity	0.61156187
10/8/6061	Equity	0.051511557
10/5/6061	Equity	0.860685859
10/6/6061	Equity	-0.191516616
10/5/6061	Equity	0.558910066
10/6/6061	Equity	0.055658656
10/1/6061	Equity	-0.566996667
9/50/6061	Equity	-0.666506606
9/69/6061	Equity	0.560666956
9/68/6061	Equity	-0.566655652
9/65/6061	Equity	-0.181656565
9/66/6061	Equity	0.569680007
9/65/6061	Equity	0.65686568
9/66/6061	Equity	0.869566057
9/61/6061	Equity	0.91181551
9/60/6061	Equity	-1.615065561
9/15/6061	Equity	-0.058655656
9/16/6061	Equity	-0.586559666
9/15/6061	Equity	0.69866606
9/16/6061	Equity	0.695616597
9/15/6061	Equity	0.595666057
9/10/6061	Equity	-0.185868681
9/9/6061	Equity	-1.005595582
9/8/6061	Equity	-0.698696588
10/18/6061	Comm	0.100965556
10/15/6061	Comm	0.518551956
10/16/6061	Comm	0.005665657
10/15/6061	Comm	-0.665565869
10/16/6061	Comm	0.595811897
10/11/6061	Comm	-0.066595161
10/8/6061	Comm	0.865866651
10/5/6061	Comm	0.590558661
10/6/6061	Comm	0.606856562
10/5/6061	Comm	-0.066665911
10/6/6061	Comm	-0.566855686
10/1/6061	Comm	-0.569561665
9/50/6061	Comm	0.556555889
9/69/6061	Comm	-1.680619609
9/68/6061	Comm	-0.681805652
9/65/6061	Comm	0.556056987
9/66/6061	Comm	0.506559566
9/65/6061	Comm	0.866561002
9/66/6061	Comm	0.966566861
9/61/6061	Comm	-1.655669567
9/60/6061	Comm	1.061919057
9/15/6061	Comm	-0.666565559
9/16/6061	Comm	0.516056866
9/15/6061	Comm	0.566508067
9/16/6061	Comm	0.616059589
9/15/6061	Comm	-0.18095666
9/10/6061	Comm	-1.000056519
9/9/6061	Comm	-0.656565907

Requirement:- Based on the selected date ,calculate cumulative values based on the formula below

need to show line graph on x axis date and y axis cumulative values and legends as category

Regards,

[amitchandak · Accepted solution]

@Anshenterprices , Assume you have base value measure of static value

Cumm =[Base Value] + CALCULATE(SUM(Table[value]),filter(allselected(Table),Table[Date] <=max(Table[Date]) && Table[category] =max(Table[category])  ))

[Anshenterprices]

@amitchandak  Thank you so much