I need help on filtering measures by dimensions

[AdrianoEllero]

=sum({<[CalendarYear]={"=CalendarYear-1"},[Material Number (Product)]={
'xyz',
}>}Quantity)

it does't work

on simple filter [Material Number (Product)]={'xyz'} is effective

[Nicolae_Alecu]

Are you using this measure into kpi or table object?

Try this:

=sum({<[CalendarYear]={"$(=CalendarYear-1)"},[Material Number (Product)]={'xyz'}>}Quantity)

Best Regards,

[AdrianoEllero]

yes either table or pitvot table

[Chanty4u · Accepted solution]

Try this

=sum({<CalendarYear={"$(=Max(CalendarYear)-1)"}, [Material Number

[AdrianoEllero]

It works! thanks so much. But why so? Is there any document that describes how to execute operation with fields?