Allexcept and slicer

[Anonymous]

Hello, guys!

I think the solution is not  difficult, but I still can't find it. Could you help me?

The task  - find measure average by filtered date perion in pivot table by each objects (object - rows, month - columns).

For this, i use such formula:

test = CALCULATE ( measure, ALLEXCEPT ( 'Calendar', 'Calendar'[Year] ))

and it works fine, till i have to use month slicer to change full year to 10 month, for example.

The "test" still calculate the whole year average.
How could I avoid it? And get dynamic average, depends on choosing months?

Lind to db: https://gofile.io/d/VLBPTf

How it should be (11 months):

Avg sales between dates
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87
25 849,87