Forum Discussion
Create summed table based on values from other rows
Hi guys, I have the following "master" table: Linked to a "slave" table: (ID in Sub Table is independent from Master Table, while "Secondary ID" is assigned by Mast...
Need a calculated table because I need to use that averaged value for other calculations. For example, I will use that averaged value to multiply times other columns to get percentages, total material consumed, etc.
Table = SUMMARIZECOLUMNS('Main Table'[ID], 'Sub Table 1'[Line],
"AverageWeight__lbs_ft_", CALCULATE(AVERAGE('Sub Table 1'[Weight (lbs/ft)]))
)I tried this, but I am not able to change its contents with filters/slicers.. any other suggestions ?
A calculated table is immutable. It cannot be influenced by filters/slicers.