YTD help in charts

[Anonymous]

I am wanting this graph to only show counts for the YTD:

The current year line drops where the current day ends. I do not want this result. 

Here is the code calculating the value:

Renewal Rate = DIVIDE(SUM(Renewals_ODW[IS_RENEWED_]), SUM('Renewals_ODW'[Contract Count]))

Any Help?

[SteveCampbell]

Do you mean you do not wish to show values after today? I am assuming there is some date column:

Renewal Rate = 

CALCULATE (
    DIVIDE (
        SUM ( Renewals_ODW[IS_RENEWED_] ),
        SUM ( 'Renewals_ODW'[Contract Count] )
    ),
    Date[date] <= TODAY ()
)

Let me know if I have misunderstood

[Anonymous]

Thanks Steve!

After applying this measure, the chart only showed the current year and the same value for every month.

I am wanting to show a Year over Year view and I want each line that represents a year to end on the current day.

For example:

2015, 2016, and 2017 all show data until the current day; November 28th

[SteveCampbell]

This may be with some relationship issue - is the date you arwe using joined correctly i.e. not time in either?
Is this data confidential? I'd be willing to have a look if you sent the file

[Anonymous]

Here is the calendar table:

Here is the facts table: (using expiration date)

Here is the relationship:

[DAX0110 · Accepted solution]

Hi @Anonymous, on the basis of @SteveCampbell's answer, if you make a slight modification it might work:

Renewal Rate = 

CALCULATE (
    DIVIDE (
        SUM ( Renewals_ODW[IS_RENEWED_] ),
        SUM ( 'Renewals_ODW'[Contract Count] )
    ),
    KEEPFILTERS( Date[date] <= TODAY () )
)

[Anonymous]

It worked, Thanks!

[parry2k]

@Anonymous share sample data as @SteveCampbell mentioned. And also share the relationship between tables, there might be something which we are not seeing..