TOTALYTD dont respect the inclusion of new column in table

[guilherme_gq]

Hi!

i created a measure "Acum" for accumulate the column "Value" for the months.

Acum= TOTALYTD( SUM ('Table'[Value]), 'Table'[Date], FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]),)"31/12")

m-YY	Value	Acum
jul/18	1	1
ago/18	2	3
set/18	3	6

This works, but my trouble is when i try to add a new column in table. When i include, the values not consider the expression. Is something like this:

Gender	m-YY	Value	Acum	Correct Value
M	jul/18	0	1	0
M	ago/18	1	3	1
M	set/18	3	6	4
F	jul/18	1	1	1
F	ago/18	1	3	2
F	set/18	0	6	2

The "Acum" repeat a value returned in table with date as single column. But now, i need the value like the colum "Correct Value", calculating the cumulative value per gender or any other column added.

Someone have any idea?

[v-jiascu-msft]

Hi @guilherme_gq,

Try this formula please. If it doesn't work, please provide a sample of the original data.

Acum =
TOTALYTD (
    SUM ( 'Table'[Value] ),
    'Table'[Date],
    FILTER ( ALL ( 'Table'[Date] ), 'Table'[Date] <= MAX ( 'Table'[Date] ) ),
    "31/12"
)

Best Regards,

Dale

[guilherme_gq]

doesnt work, Dale. 

Download sample here! I separated in two tables, with wrong value when i include state in first table.

https://ufile.io/8osmc

[v-jiascu-msft · Accepted solution]

Hi @guilherme_gq,

Since you have used the TotalYTD, we don't need to filter dates like that. Please try the formula below. And the date context should be in the table visual.

TotalSaldoAcumYTD 3 =
TOTALYTD ( SUM ( Agregados[TotalSaldoAcum] ), Agregados[AnoMes], "31/8" )

NOTE: any link here is available to the whole internet. Please don't input sensitive data.

Best Regards,

Dale

[guilherme_gq]

Thanks, Dale!

thats worked 

about your note, dont worry. This case is a simulation based in sample datased that i downloaded.