Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
i'm using power BI desktop for calculate a cumulative sum froma about 120,000 Rows, but the performance it's very bad. Took about 5 minutes to fill about 15G of ram and couldnt finish. im using this dax to calculate the acumuluative total
Cumulative Quantity =
CALCULATE (
SUM ( 'Sales SalesOrderDetail'[LineTotal] ),
FILTER (
ALL ( 'Table' ),
'Table'[Index] <= MAX ( 'Table'[Index] )
)
)
Any ideas how to make more faster or efficient a acumulative sum with more than 30,000 rows? if i test for example with 20000 this works well but above 30000 isnt work.
User | Count |
---|---|
11 | |
9 | |
6 | |
5 | |
4 |