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
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • 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 ?