cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oldhasbeen Regular Visitor
Regular Visitor

Problems with DAX Date filter

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

 

DAXF4.PNG

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:

 

DAXF3.PNG

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

 

Thanks!

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
HotChilli Senior Member
Senior Member

Re: Problems with DAX Date filter

Hi again,

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

YEAR(Sales[OrderDate]) = 2019)
2 REPLIES 2
Highlighted
HotChilli Senior Member
Senior Member

Re: Problems with DAX Date filter

Hi again,

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

YEAR(Sales[OrderDate]) = 2019)
oldhasbeen Regular Visitor
Regular Visitor

Re: Problems with DAX Date filter

Thanks!

 

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