Can I accumulate a measure?

[Anonymous]

I created a measure in which i calculated an indicator and now i want that indicator to be accumulated. 

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Refer:

Measure = SUMX(FILTER(ALLSELECTED('Table'),'Table'[yearmonth]<=MAX('Table'[yearmonth])),[ind_rotacion])

Best Regards,

Jay

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Refer:

Measure = SUMX(FILTER(ALLSELECTED('Table'),'Table'[yearmonth]<=MAX('Table'[yearmonth])),[ind_rotacion])

Best Regards,

Jay

[Anonymous]

Thank you so much for your reply jay,

when i used this solution the result i get is the accumulative sum of the rotation, even when i am summing the measure ind_rotation 

[Syndicate_Admin]

Hello guyes,

I´ve the same probleam as @steveruiz...
Thank you in advanced

[BA_Pete]

@Anonymous ,

I presume you mean accumulated over time, in which case you can use functions like DATESYTD, TOTALYTD as long as you've got a correctly set-up calendar table.

Pete

[selimovd]

Hey @Anonymous ,

can you give more details?

Accumulated by what? By time? By year? By product?

Best regards

Denis

[Anonymous]

Hey Denis (@selimovd),

Thank you for your time, I'm acummulating by time it's a monthly indicator and i have the date, and a colum for the month and year! 

This is the measure i'm using and i need to acummulate the result it gives me :

ind_rotacion =

VAR rota_colab =

SUM(ROTACION[ROTACION])

VAR totalcolaborador=

COUNT('BD Consolidado'[Contrato])

RETURN

DIVIDE(rota_colab,totalcolaborador)

[selimovd · Accepted solution]

Hey @Anonymous ,

I think an approach like the following should work:

ind_rotacion_TD =
VAR rota_colab =
    CALCULATE (
        SUM ( ROTACION[ROTACION] ),
        DATESBETWEEN (
            myDateTable,
            FIRSTDATE ( ALL ( myDateTable[Date] ) ),
            LASTDATE ( myDateTable[Date] )
        )
    )
VAR totalcolaborador =
    CALCULATE (
        COUNT ( 'BD Consolidado'[Contrato] ),
        DATESBETWEEN (
            myDateTable,
            FIRSTDATE ( ALL ( myDateTable[Date] ) ),
            LASTDATE ( myDateTable[Date] )
        )
    )
RETURN
    DIVIDE ( rota_colab, totalcolaborador )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Thank you so much for your answer,

When i used your solution i did not get the correct result. Attached you may find a table with a column in green with the result i need and in yellow with the result i'm getting