Forum Discussion

cecitorresHF's avatar
cecitorresHF
Icon for Helper I rankHelper I
4 years ago
Solved

Total Acumulado

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)

 

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

3 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    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!!

     

  • cecitorresHF's avatar
    cecitorresHF
    Icon for Helper I rankHelper I
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.