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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Does this measure work?

=CALCULATE(COUNTROWS(WKO),DATESYTD(Calendar[Date],"31/12"))

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

Hello Ashish - No sir. This is similiar to last time with a flat bar (not running total).

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    Share the link from where i can download your PBI file.

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

      Hello Ashish - 

       

      Here ya go. This is with some sample data.  Should be good enough to replicate the issue. Have a generic calendar table. Have another table with some dates. How to make the slider control the starting point for a running total/cumulative total.

       

      Nick

       

      https://1drv.ms/u/s!AlWk_fvRgbyDoDsGBjSdaNP6D7aS?e=5ezNqx

       

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

        Hi,

         

        For your sample02, please try this measure:

         

        Measure = 
CALCULATE (
    COUNTROWS ( WKO ),
    FILTER (
        WKO,
        WKO[CompletedDate] <= MAX ( 'Calendar'[Date] )
            && WKO[CompletedDate] <> BLANK ()
    )
) + 0

         

        The result shows:

        See my attached pbix file.

         

        Best Regards,

        Giotto

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    Is this what you want?  Download the PBI file from here.

    Hope this helps.

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

      Hello Ashish - No, this doesn't work. These are not running totals and is not affected by the slider. Did you upload the right file? Can you demonstrate how this answers my question? Unsure if I am missing something here.