problem with ALLEXCEPT

[mechanix85]

Hello. I have a plan-fact table for managers. For the fact, there are additional columns with information that will need to be filtered in the pivot table, while the plan for managers should not change. I use ALLEXCEPT, but this only works for one additional column

Who can help? thanks

source table

managers	plan	fact	town	focus
№1		421​	town1	y
№2		362​	town1	n
№3		256​	town2	y
№1		427​	town3	n
№2		418​	town2	y
№3		336​	town4	n
№1	5000​
№2	6000​
№3	7000​
#4	1000​

!fact:=SUM([fact])
!plan:=CALCULATE(sum([plan]);ALLEXCEPT('Таблица1';'Таблица1'[managers]))

pivot table with 2 two slices town and focus

Названия строк	!plan	!fact
#4	1000​
№1	5000​	848​
№2	6000​	780​
№3	7000​	592​
Общий итог	19000​	2220​

pivot table filtered by focus = "n"

Названия строк	!plan	!fact
№1	5000​	427​
№2	6000​	362​
№3	7000​	336​
Общий итог	19000​	1125​

manager #4 removed from table
how i want to see the table filtered by focus = "n"

Названия строк	!plan	!fact
#4	1000​
№1	5000​	427​
№2	6000​	362​
№3	7000​	336​

that is, I can apply filters while the plan will always be displayed for all managers