Problems with DAX Date filter

[Anonymous]

Hi

I'm quite new to DAX and am experimenting with filters in CALCULATE, using a simple table of sales data containing data from 2017 to 2019 - here's an extract

Source data is at https://1drv.ms/x/s!AmxJyApgEAcYgtUghDmk57MBicCw0A

I've set up a measure to sum only order class "P" sales:

Priority Class Sales = CALCULATE(SUM(Sales[Sale£]),OrderClasses[Order Class]="P") 

and another to just sum sales in 2019:

Sales in 2019 = calculate(SUM(Sales[Sale£]),YEAR(Sales[OrderDate]=2019))

Here's what happens when I use them in a table:

Could someone explain why the "Priority Class Sales" filter works while the "Sales in 2019" filter appears to have no effect?

Thanks!

[HotChilli · Accepted solution]

Hi again,

the bracket is in the wrong place in the measure. Should be

YEAR(Sales[OrderDate]) = 2019)

[Anonymous]

Thanks!

What a difference a misplaced bracket makes! I should have spotted this myself.