The DAX formula is not working when year is filtered by calender table

[shoaib944]

The DAX formula is not working properly when year is filtered by calender table.

Revenue_2010 = CALCULATE(SUMX('Online Retail','Online Retail'[Quantity]*'Online Retail'[UnitPrice]),

FILTER(ALL('Online Retail'),YEAR('Online Retail'[InvoiceDate])=2010)) --- working correctly

Revenue_2010 = CALCULATE(SUMX('Online Retail','Online Retail'[Quantity]*'Online Retail'[UnitPrice]),

FILTER(ALL('Calendar'),YEAR('Calendar'[Date])=2010)) --- not working

Can somebody please help me in understanding this?

[ppm1]

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