excel 3

calcilated columns can use related function to get other table (extendedrow context)
measuresupdatedby context like slicers filters.  grandtotal not necesarily sum of all. you can redefine in equation (filter context)

implicit meas is drag values
explicitis measures typing :=

hiding tables by right clicking worksheet tab below keeps calculated columns with related
power pivot tab data model
tablenamequotation special chars
after flashfill its text so conver to numbers rclk