Forum Discussion
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 th...
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.
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.