Cummulative Percentage for Large Dataset (> 50,00 Rows)

kachilem — Tue, 10 Dec 2019 06:57:02 GMT

Hello,

Please, I need urgent help getting a measure that will calculate cummulative percentage for a large dataset (> 50,000 rows). The ones I have found so far end up crashing and not producing the expected result. The result I need is in Excel Cummulative % col. The highlighted rows shows the problem I am having with the DAX measures when the is duplicate lines in the data.

Thanks in advance for your help.

Part No	Lines	DAX Cummulative Line	DAX Cummulative %	Excel Cummulative Lines	Excel Cummulative %
A	3149	3149	10.86	3149	10.86
B	1291	4440	15.31	4440	15.31
C	1219	5659	19.51	5659	19.51
D	1162	6821	23.52	6821	23.52
E	1052	7873	27.15	7873	27.15
F	913	8786	30.29	8786	30.29
G	897	9683	33.39	9683	33.39
H	895	10578	36.47	10578	36.47
I	882	11460	39.51	11460	39.51
J	866	12326	42.50	12326	42.50
K	828	13154	45.36	13154	45.36
L	816	13970	48.17	13970	48.17
M	799	14769	50.92	14769	50.92
N	774	15543	53.59	15543	53.59
O	763	16306	56.22	16306	56.22
P	760	17826	61.46	17066	58.84
Q	760	17826	61.46	17826	61.46
R	745	18571	64.03	18571	64.03
S	742	19313	66.59	19313	66.59
T	716	20029	69.06	20029	69.06
U	711	20740	71.51	20740	71.51
V	709	21449	73.96	21449	73.96
W	708	22157	76.40	22157	76.40
X	704	22861	78.83	22861	78.83
Y	700	23561	81.24	23561	81.24
Z	699	24260	83.65	24260	83.65
AA	686	24946	86.01	24946	86.01
AB	684	25630	88.37	25630	88.37
AC	677	27661	95.38	26307	90.71
AD	677	27661	95.38	26984	93.04
AE	677	27661	95.38	27661	95.38
AF	671	28332	97.69	28332	97.69
AG	670	29002	100.00	29002	100.00

Re: Cummulative Percentage for Large Dataset (> 50,00 Rows)

kentyler — Wed, 11 Dec 2019 05:10:10 GMT

Could you post the measures you are trying to use that crash......50,000 rows should not be "large" for DAX, millions of rows maybe, but not 50,000.

Re: Cummulative Percentage for Large Dataset (> 50,00 Rows)

kachilem — Wed, 11 Dec 2019 20:11:38 GMT

To Calculate the DAX Cummulative Total I used this command: DAX Cummulative Total = CALCULATE([SumLines],FILTER(ALL(Query12_Q1),Query12_Q1[LINES] >= MAX(Query12_Q1[LINES]))) and SumLines = CALCULATE(SUM(Query12_Q1[LINES]))

These by the way are not giving me the results I need as i mentioned in my original post.

topic Re: Cummulative Percentage for Large Dataset (> 50,00 Rows) in DAX Commands and Tips

Cummulative Percentage for Large Dataset (> 50,00 Rows)

Re: Cummulative Percentage for Large Dataset (> 50,00 Rows)

Re: Cummulative Percentage for Large Dataset (> 50,00 Rows)