Total Acumulado

[cecitorresHF]

Hola, estoy intentando crear una columna con totales acumulados para la columna 'Prioritised Jobs' por semana. Esta es mi tabla actual. (40, 41, 42, etc son semanas)

[cecitorresHF]

Thanks, but this is not working because all the columns are measuremets 

[v-rzhou-msft · Accepted solution]

Hi @cecitorresHF 

Try sumx funtcion to calculate the sum of measure. 

Here is my sample.

Measure:

M_Prioritised Jobs = SUM('Table'[Prioritised Jobs])

Cumulative Total =
SUMX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Month] = MAX ( 'Table'[Month] )
            && 'Table'[level1] <= MAX ( 'Table'[level1] )
    ),
    [M_Prioritised Jobs]
)

Result is as below.

Best Regards,
Rico Zhou

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

[VahidDM]

Hi @cecitorresHF 

Try this to add a column to your table:

Column = calculate(sum([Prioritised Jobs]),filter(all(table),[Prioritised Jobs]<=earlier([Prioritised Jobs]))))

Or this, measure:

Column = calculate(sum([Prioritised Jobs]),filter(all(table),[Prioritised Jobs]<=Max([Prioritised Jobs]))))

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

Appreciate your Kudos!!