ABC Classification_MS.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2								This column is what I need as a DAX measure - Cumulative Sales	Cum Sales Attempt 1	Cum Sales Attempt 2		This column is what I need as a DAX measure - Cumulative Sales %	Cum % Attempt 1
3	Period	All
4
5		Values
6	PN	Sales_Count	Sales_Frequency	Sales_Average	Sales_AverageDeviation	Sales_Variation	Sum of Sales	Sum of Sales2	Test_CumulativeSales1	Test_CumulativeSales2	Test_bhelou	Sales_Percentage	Sales_Percentage2	Test_Cumulative%
7	10949268	12	F	15,349	1,638	Balance/Smooth	184,192	184,192	184,192	765,243	184192	24%	24%	46.75
8	10937285	12	F	4,552	1,488	Balance/Smooth	54,625	238,817	54,625	565,895	54625	7%	31%	13.86
9	10936812	12	F	4,342	1,075	Balance/Smooth	52,099	290,916	52,099	581,051	52099	7%	38%	13.22
10	10937276	12	F	3,913	1,143	Balance/Smooth	46,957	337,873	46,957	551,137	46957	6%	44%	11.92
11	10940399	12	F	3,432	1,695	Needs Balance	41,188	379,061	41,188	573,357	41188	5%	49%	10.45
12	10936803	12	F	3,255	1,196	Balance/Smooth	39,054	418,115	39,054	536,878	39054	5%	54%	9.91
13	10949274	12	F	3,009	486	Balance/Smooth	36,103	454,218	36,103	428,424	36103	5%	59%	9.16
14	10992773	12	F	2,831	417	Balance/Smooth	33,974	488,192	33,974	416,448	33974	4%	63%	8.62
15	10981252	12	F	2,811	545	Balance/Smooth	33,736	521,928	33,736	408,474	33736	4%	68%	8.56
16	10936806	12	F	2,792	650	Balance/Smooth	33,508	555,436	33,508	448,713	33508	4%	72%	8.50
17	10947503	12	F	2,532	430	Balance/Smooth	30,387	585,823	30,387	358,307	30387	4%	76%	7.71
18	10986197	12	F	2,489	267	Balance/Smooth	29,866	615,689	29,866	290,185	29866	4%	80%	7.58
19	10947694	12	F	2,480	576	Balance/Smooth	29,765	645,454	29,765	444,540	29765	4%	84%	7.55
20	10941656	12	F	2,287	783	Balance/Smooth	27,441	672,895	27,441	436,418	27441	4%	87%	6.96
21	21004011	12	F	2,151	558	Balance/Smooth	25,806	698,701	25,806	306,284	25806	3%	90%	6.55
22	10940390	12	F	2,065	1,117	Needs Balance	24,777	723,478	24,777	485,114	24777	3%	94%	6.29
23	10940393	12	F	2,051	1,035	Needs Balance	24,614	748,092	24,614	404,500	24614	3%	97%	6.25
24	10997100	12	F	2,011	265	Balance/Smooth	24,135	772,227	24,135	168,902	24135	3%	100%	6.13
25	Grand Total	216	F	3,575	15,365	Non-stable	772,227		772,227	765,243		100%		196
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100