Forum Discussion
Cumulative Total DAX
llavey Is this a trick question?
Get rid of the condition...
Cumulative Extr Qty Fails :=
CALCULATE (
SUM ( 'A'[Extrapolated Qty] ),
FILTER ( ALLSELECTED ( 'A' ), A[Year-Month] <= MAX ( 'A'[Year-Month] ) )
)
Why would i get rid of this? I need it for the Cumulative DPM for each month?
So, you've added another Cumulative Ext Qty Fails column to the pivot and made it a running total, which works great. The problem is I have a Cumulative Ext DPM column which will take the Cumulative Ext Qty Fails/Cumulative Exp Shipments*1000000 for each month. Any idea how to accomodate that if I get rid it?
Right now, i have another DAX formula for the Cumulative DPM that uses the Cumulative Extr Qty Fails:
Cumulative Extr DPM:=([Cumulative Extr Qty Fails]/[Cumulative Exp Shipments])*1000000
Maybe i'm making this way harder than it should be.
As far as this new question...
What is Cumulative Exp Shimpments? It was not included in the sample data?