Forum Discussion

Mohan_sc's avatar
Mohan_sc
Frequent Visitor
4 years ago

Slicer for Running Total

Hello All,

I'm working on on of the Running total Project. These are my below mesures.

zCount TDD Planned running total in Date =
VAR LastCompDate = CALCULATE( LASTDATE('Burndowns (Append)'[AxTDD DueDate]),ALL('Burndowns (Append)'))
Return
If( SELECTEDVALUE('Date'[Date]) > LastCompDate, BLANK(),
CALCULATE(
    [zCount TDD Planned],
    FILTER(
        ALLSELECTED('Date'[Date]),
        'Date'[Date] <= MAX('Date'[Date])
    )
))
 
 
Issues -
When I'm  applying slicers Running total not stoping for MAX date of column. Please see below

 

Need Help

3 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Mohan_sc ,

     

    Based on your description, I have created a simple sample:

    Here is the measure:

     

    Measure = 
var _a = CALCULATE(LASTDATE('Burndowns (Append)'[Date]),ALL('Burndowns (Append)'))
return IF(SELECTEDVALUE('Burndowns (Append)'[Date])>_a,BLANK(),CALCULATE(MAX('Burndowns (Append)'[A]),FILTER(ALLSELECTED('Date'[Date]),'Date'[Date]<=MAX('Date'[Date]))))

     

    Output:

     

    Maybe I misunderstood? If this is not what you want, can you please share more details to help us clarify your scenario?

    Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Refer to:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Mohan_sc's avatar
      Mohan_sc
      Frequent Visitor
      4 years ago

      Thnk you for your respond.. please go through below
      This is my Data table

      This is my Intiative slicers

       

      This is my Line chart

       

      It's work fine without slicers. But when you applying slicers the count not stoping for end of the maxium date.Please see below. It need to be stop 9/22/2023