Forum Discussion
Cumulative Total DAX
Row Labels Sum of Ext Qty Cumulative Extr Qty Fails Sum of DELIVERY_QTY_EXP Extr DPM Cumulative Extr DPM 2015-11 224 223.7605022 222,282,787 1.0 1.0 2015-12 315 539.1262961 174,...
All I really did was just modify the Measure which sums the values in [Sum of Ext Qty] column - nothing else
That zero is from the sample data you posted - I included it in the Matrix just to compare - I have not created any columns
if you have a calendar with a relationship you could try this
Cumulative Extr Qty Fails:=calculate(
sum ('A'[Sum of Ext Qty])
,FILTER(all('Calendar'[Date]),
'Calendar'[Date]<=MAX('Calendar'[Date])))