Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cumulative counts on line/bar graphs

Hi all,    I have a measure which I use to count cumulative registrations - it's simple and it has mostly worked: Cumulative = CALCULATE (     COUNT ( 'Team'[DateRegistered]),     FILTER (    ...
Need Help
  • negi007's avatar
    negi007
    3 years ago

    Anonymous You will have do the calc at the year to have running total for each year. your measaure could be like below

    Vol running total in Year =
    CALCULATE(
        SUM('Table'[Vol]),
        FILTER(
            ALLSELECTED('Table'[Date].[Year]),
            ISONORAFTER('Table'[Date].[Year], MAX('Table'[Date].[Year]), DESC)
        )
    )
     
     here is the expected output

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago


negi007 Thank you again for this solution, it works perfectly on years - but when I need to use months and years (as if I just use month the count doesn't work) I am struggling with what changes I need to make? Is it an adjustment to this code, or an entirely new approach that is required? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    That looks great - thank you!