Forum Discussion

llavey's avatar
llavey
Regular Visitor
10 years ago

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,...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

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] ) )
)
  • llavey's avatar
    llavey
    Regular Visitor
    10 years ago

    Why would i get rid of this?  I need it for the Cumulative DPM for each month?

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      llavey Not sure what you mean?

       

      • llavey's avatar
        llavey
        Regular Visitor
        10 years ago

        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.