Forum Discussion

kachilem's avatar
kachilem
Frequent Visitor
6 years ago

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

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 NoLinesDAX Cummulative LineDAX Cummulative %Excel Cummulative LinesExcel Cummulative %
A3149314910.86314910.86
B1291444015.31444015.31
C1219565919.51565919.51
D1162682123.52682123.52
E1052787327.15787327.15
F913878630.29878630.29
G897968333.39968333.39
H8951057836.471057836.47
I8821146039.511146039.51
J8661232642.501232642.50
K8281315445.361315445.36
L8161397048.171397048.17
M7991476950.921476950.92
N7741554353.591554353.59
O7631630656.221630656.22
P7601782661.461706658.84
Q7601782661.461782661.46
R7451857164.031857164.03
S7421931366.591931366.59
T7162002969.062002969.06
U7112074071.512074071.51
V7092144973.962144973.96
W7082215776.402215776.40
X7042286178.832286178.83
Y7002356181.242356181.24
Z6992426083.652426083.65
AA6862494686.012494686.01
AB6842563088.372563088.37
AC6772766195.382630790.71
AD6772766195.382698493.04
AE6772766195.382766195.38
AF6712833297.692833297.69
AG67029002100.0029002100.00
 

2 Replies

  • kentyler's avatar
    kentyler
    Icon for Solution Sage rankSolution Sage
    6 years ago

    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.

    • kachilem's avatar
      kachilem
      Frequent Visitor
      6 years ago

      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.