Use Year to Go (YTG) measure with Time Intelligence

[goncalogeraldes]

I was working on an old report in the company where they initially did not use a date dimension so I created one to lighten up the file. The problem is, previously, the YTG measure used to work just fine and now, no matter how much I change it, it does not work.

The previous formula was just like Greg Deckler suggested in: https://community.powerbi.com/t5/Desktop/Calculate-YTG-Year-to-Go/m-p/476531 .

While currently it looks like this:

Year To Go = 

VAR __today = TODAY()
VAR __maxDate = DATE(YEAR(TODAY()),12,31)

RETURN 
    CALCULATE(
        SUM(POWERBI_V_SALES[Amount]),
        FILTER(
            Dim_Date,
            Dim_Date[Date_Key] > __today && Dim_Date[Date_Key] <= __maxDate
        )
    )

It just returns blank all the time... Do you have any suggestions? Thank you!

[CNENFRNL]

9 out of 10, so-called issues arise from negligence of comprehensive filter context, under which a measure evaluates. Your measure seems correct alone; but filter context matters.

[PaulOlding]

Is Dim_Date[Date_Key] a date field?

[goncalogeraldes]

Dim_Date[Date_Key] is the column with the Dates in the date dimension that I created