Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The DAX formula is not working properly when year is filtered by calender table.
FYI that it is better practice (and more performant) to add a Year column to your Calendar table and use a measure expression like this. Also, please confirm that you have a 1:M relationship between the tables, and that you are not using the 'Calendar'[Date] column in the visual already (you can but a different expression likely needed).
Revenue_2010 =
CALCULATE (
SUMX ( 'Online Retail', 'Online Retail'[Quantity] * 'Online Retail'[UnitPrice] ),
'Calendar'[Year] = 2010
)
Pat
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |