Problems with DAX Date filter

Anonymous — Sun, 26 May 2019 08:11:26 GMT

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!

Re: Problems with DAX Date filter

HotChilli — Sun, 26 May 2019 19:39:15 GMT

Hi again,

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

YEAR(Sales[OrderDate]) = 2019)

Re: Problems with DAX Date filter

Anonymous — Mon, 27 May 2019 07:02:10 GMT

Thanks!

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

topic Re: Problems with DAX Date filter in DAX Commands and Tips

Problems with DAX Date filter

Re: Problems with DAX Date filter

Re: Problems with DAX Date filter