How can I accumulate a % in dates in DAX

[emadrigals104]

Hi everyone, 

I am trying to perform a function that allows me to accumulate the percentage, but not using the traditional method with DATESYTD, because it takes the amounts and not the results of the monthly percentages.

The idea is to create both measure 1, as well as measure 2, which is the one that accumulates.

I appreciate your help.

[tamerj1]

Hi @emadrigals104 

please try

Measure1 Correct Total =
SUMX ( VALUES ( 'Date'[Month] ), [Measure1] )

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

Expected measure: =
CALCULATE (
    SUMX ( Data, Data[Value2] / Data[Value1] ),
    FILTER ( ALL ( Data ), Data[Date] <= MAX ( Data[Date] ) )
)