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,...
How do i modify my formula to always show running total, even if Sum of Ext Qty = 0?
My DAX formula:
Cumulative Extr Qty Fails:=calculate(if(sum('A'[Extrapolated Qty])=BLANK(),0,sum ('A'[Extrapolated Qty])),FILTER(ALLSELECTED ('A'),A[Year-Month]<=MAX ('A'[Year-Month])))
llavey I believe i answered your original Question...
And no I did not create any new columns.
All I did was change the MEASURE formula....