Perform TOTALYTD with fixed existing measure

[ADA371]

Hi all ! 

I have a real problem to perform a specific calculation with power bi desktop... 

I try to do a TOTALYTD based on an existing Measure but it doesnt work. 

My existing Measure is: PPM_Performance = (SUM(PPM_Nombre_avis)/SUM(PPM_Nbr_Lignes))*1000000

My YTD Measure: PPM Performance YTD = TOTALYTD([PPM Performance],DIM_Temps[Caldate])

Result for 2021 Février is: 242.31

Expected Result is: 484 (233+251)

I think the solution is to fix the result of the existing measure PPM Performance but the new measure PPM Performance YTD do nex calculation with SUM of PPM_Nombre_avis and PPM_Nbr_Lignes from the beginning of the year... 

My Datas:

Thank you for your help

[DataInsights · Accepted solution]

@ADA371,

Try this measure. Your date table needs a year/month column such as [Year Month Num] (e.g., 202101).

PPM Performance YTD =
CALCULATE (
    SUMX ( VALUES ( DimDate[Year Month Num] ), [PPM_Performance] ),
    DATESYTD ( DimDate[Date] )
)