Forum Discussion

BLM's avatar
BLM
Icon for Helper I rankHelper I
8 years ago
Solved

Cumulative Totals

hello guys!!

I need an aummulative summ by date (only selected in slicer) and by another field (stock OPs). I attached a image for  show that I need. Thank you (sorry for my english)

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi BLM,

     

    You need a measure like this:

    Measure =
CALCULATE (
    SUM ( movimientos[Cantidad] ),
    FILTER (
        ALLSELECTED ( 'calendar' ),
        'calendar'[fecha] <= MAX ( 'calendar'[fecha] )
    )
)

    Cumulative_Totals

     

    Best Regards,

    Dale

5 Replies

  • BLM's avatar
    BLM
    Icon for Helper I rankHelper I
    8 years ago

    I`m used this formula, but don`t work, summ all whitout date filter...

    • BLM's avatar
      BLM
      Icon for Helper I rankHelper I
      8 years ago

      help me please...:smileyfrustrated:

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi BLM,

         

        Can you share a dummy sample? It's hard to write a DAX formula without the data model.

         

        Best Regards,

        Dale