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

     

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

Anonymous 

Cumulative = CALCULATE (
    COUNT ( 'Team'[DateRegistered]),  
        'Team'[DateRegistered] <= MAX ( 'Team'[DateRegistered])
)

 

 

Anonymous if it's not work please share your sample data and sample output in table format? Or a sample pbix after removing sensitive data.