Dynamic Column calculation based on Slicer Selection

I've tried a number of solutions using ALLSELECTED (and various combinations of pivoted and unpivoted columns), and nothins seems to be working - I suspect my syntax is off.  In my most recent attempt, I was able to summarize all of the market size columns into a single column so that my input data now looks like the Sample Data below.  I've tried a few approaches, including calculating a column or set of columns to get my desired result, but nothing quite works.  My most recent approach was to try and create a table based on summarizing the existing one using

Table = SUMMARIZE(Sheet1,Sheet1[Office],"Filtered Revenue",CALCULATE(SUM(Sheet1[Revenue]),ALLSELECTED(Sheet1[Industry Classification]),ALLSELECTED(Sheet1[Project Size])),"Filtered Market Size",CALCULATE(sum(Sheet1[Attributable Market Size]),ALLSELECTED(Sheet1[Industry Classification]),ALLSELECTED(Sheet1[Project Size])))

This syntax yields the output pictured below, regardless of what slicers are applied.  I've used similar expressions (with adjustments to suit the calculation result, e.g. column vs measure vs table) to try and calculate columns and measures in my existing table and gotten similar results.  Can anyone point me in the direction of where I'm going wrong?

Sample DataResult of DAX code