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
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