Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 Help
lbendlin's avatar
lbendlin
Super User
4 years ago
Table = SUMMARIZECOLUMNS('Main Table'[ID], 'Sub Table 1'[Line],
      "AverageWeight__lbs_ft_", CALCULATE(AVERAGE('Sub Table 1'[Weight (lbs/ft)]))
    )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I tried this, but I am not able to change its contents with filters/slicers.. any other suggestions ?

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    A calculated table is immutable. It cannot be influenced by filters/slicers.