DAX - YTD/Running : Stop summing up for repeated values in the reference column.

[ippman]

Hello!

I'm having trouble modifying my dax code for the running total measure "Test Active FTEs (YTD)" so that it doesn't sum the values that repeat in the column "TEST Active FTEs" as shown in the image below. Please advise.

Here is the pbix file : YTD/Running Count Issue.pbix 

TEST Active FTEs =
CALCULATE (
    DISTINCTCOUNT ( EMP_TRAN_FACT[HR Employee ID] ),
    EMP_TRAN_FACT[HR Employee Event Type] = "ACTIVE"
)

Test Active FTEs (YTD) =
CALCULATE (
    SUMX ( VALUES ( DIM_DATE[Month Id] ), CALCULATE ( [Test Active FTEs] ) ),
    DATESYTD ( DIM_DATE[Date] )
)