Forum Discussion

Nicho247's avatar
Nicho247
Icon for Helper III rankHelper III
6 years ago

Cumulative Total Help - Slicer sets starting date

Hello -    Working on a basic running/cumulative total. I have it working but it is grabbing all dates in my table. I'd like it to compute starting from the date present in a slicer. I've poked aro...
Need Help
Nicho247's avatar
Nicho247
Icon for Helper III rankHelper III
6 years ago

Hello Giotto - Thank you for your recommendation. Unfortunately this provides a bizarre reverse cumulative total. It does appear to be affected by the date sliders but not in the inteded fashion.  Unsure if it is also counting from the data set or from the sliders. Visually the slider is taken into account.

 

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Please try this:

Cumulative OnTime =
CALCULATE (
    COUNTROWS ( WKO ),
    FILTER ( WKO, WKO[CompletedDate] <= SELECTEDVALUE ( 'Calendar'[Date] ) )
)

Or this:

Cumulative OnTime =
CALCULATE (
    COUNTROWS ( WKO ),
    FILTER (
        ALLSELECTED ( WKO ),
        WKO[CompletedDate] <= SELECTEDVALUE ( 'Calendar'[Date] )
    )
)

 

Best Regards,

Giotto

  • Nicho247's avatar
    Nicho247
    Icon for Helper III rankHelper III
    6 years ago

    Hello Giotto -

     

    The first measure does create the running total, but it unaffected by the slicer data. 

     

    The second measure also creates the running total but removes the ability to use the legend, and is unaffected by the slicer data.

     

    😞

     

    Nick