Date Measure Graphing Issue

[Anonymous]

When I use this measure:

Open MOCs = 
VAR Currentdate = MAX(Dates[Date])
VAR ActiveMOCs = 
CALCULATE(
    DISTINCTCOUNT(data[MOC Number]),
    ALL(Dates),
    Dates[Date]<=Currentdate,
    (ISBLANK(data[Close Date]) && ISBLANK(data[Cancelled Date]))
    ||data[Close Date]>=Currentdate
    ||data[Cancelled Date]>=Currentdate
)
Return
ActiveMOCs

I get the right result, but when I make a line graph (using the measure above and year/month) and filter to dates from the last year, then a get results that are much smaller than I expect.

Any idea what I am doing wrong?

[amitchandak]

@Anonymous , Please refer to my HR blog, This can help to find active between 2 dates

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Anonymous]

I am able to find the number active, the issue is when I want to graph it and only see the last year. Once I apply that filter it's applying it to all the dates and then my numbers are off.