I have a table with many fields, including year and region. I need total sum for sales per region and Year, and I want these total sums to be responsive to year/region filter/slicer Only; all other fields will not affect the Total sum.

PS. ALLEXCEPT doesn't work well, because I have a lot of fields

<https://i.stack.imgur.com/rsBfm.png>

Edit: i'm looking solution for PowerPivot (not for PowerBI); Data Model is base for pivots.