Calculation error in measure for last year Sales?

[Anonymous]

Hey, 

I am trying to Filter last year sales, but I am getting an error. Please see below for my formula. 

Total Sales = SUM(Sales_Details[TotalPrice])

2018 Forecast =
CALCULATE([Total Sales],
FILTER(Dates, Dates[Sales Data].[Year] = "2018"))

Error - 

Please click here for the sample file. 

Can anybody please tell me what I am doing wrong?

Thank you so much

[ChrisMendoza · Accepted solution]

@Anonymous -

It looks like you've enclosed "2018" as a text string. Take out the quotes or change the Data Type to Text

[d_gosbell · Accepted solution]

You have quotes around the value 2018 which tells DAX to treat that value as text instead of a number. Removing the quotes around 2018 should fix this issue.

eg

2018 Forecast =
CALCULATE([Total Sales],
FILTER(Dates, Dates[Sales Data].[Year] = 2018 ))

[Anonymous]

Thank you all for your help. I really appreciate it. 

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

Dates[Sales Data].[Year] returns a value(whole number), but "2018" is text so they are different types.

So you need to use Dates[Sales Data].[Year] = 2018 or FORMAT(Dates[Sales Data].[Year],"0000") = "2018".

[d_gosbell · Accepted solution]

You have quotes around the value 2018 which tells DAX to treat that value as text instead of a number. Removing the quotes around 2018 should fix this issue.

eg

2018 Forecast =
CALCULATE([Total Sales],
FILTER(Dates, Dates[Sales Data].[Year] = 2018 ))

[ChrisMendoza · Accepted solution]

@Anonymous -

It looks like you've enclosed "2018" as a text string. Take out the quotes or change the Data Type to Text