Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Running total per age group (no date-column)

What am I doing wrong? I need to find the average age group that people die of COVID-19. So I thought first to make a calculated column of Running Total deaths per age category. And then find the va...
Need Help
miltenburger's avatar
miltenburger
Icon for Helper V rankHelper V
6 years ago

Hi Anonymous 

 

Can you try following:

 

 

Cumulative Quantity =
CALCULATE (
    SUM ( 'Confirmed COVID-19 cases by sex and age'[Deaths] ),
    FILTER (
        ALL ( 'Confirmed COVID-19 cases by sex and age' ),
        'Confirmed COVID-19 cases by sex and age' [Index] <= MAX ( 'Confirmed COVID-19 cases by sex and age' [Index] )
    )
)