Forum Discussion
Brise
1 year agoRegular Visitor
Cummulative sum with slicer, big table
Hi, can you help me with this issue? I have a big table (1600 millions of row) connect to power query with some slicers for consulting of a little part of this table and extract a "mini table" wi...
danextian
Super User
1 year agoHi Brise
Here's what I would:
- Split the datetime into separate date and time components to reduce cardinality and create a smaller footprint.
- Apply the cumulative calculation to a column with low cardinality. Doing this on a column with high distinct values, like Fecha Mov, is not ideal. Referring to the first point, use separate date and time/hour dimensions, relate them to your fact table, and apply the cumulative calculation to those columns.
Cumulative Sum =
CALCULATE (
[Sum of Values],
FILTER ( ALL ( Dates ), Dates[Date] <= MAX ( Dates[Date] ) ),
FILTER ( ALL ( 'Hours' ), Hours[Hour] <= MAX ( 'Hours'[Hour] ) )
)
Please see the attached sample pbix.
Brise
1 year agoRegular Visitor
Not working , because this filter all and I need filter all inside the context of slice filtering