Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi again,
the bracket is in the wrong place in the measure. Should be
Hi again,
the bracket is in the wrong place in the measure. Should be
Thanks!
What a difference a misplaced bracket makes! I should have spotted this myself.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |