Create summed table based on values from other rows

[Anonymous]

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 Master Table as a relationship)

Some production lines have 2 sides, "a" and "b".

I would like to:

1. create a calculated table where:
   1. Line X's weight, from both sides a and b, appear as one "summarized" averaged value.
      1. Example 1: For SECONDARY ID #1 above: Line 2a and 2b the "summarized averaged" value for Weight = 0.26 (since 0.26+0.26/2 = 0.26).
      2. Example 2: Line 3a and 3b "summarized average value" would be = 2.8205 (since 2.808 + 2.833 = 2.8205)
      3. Etc.
2. This summarized table would show me also the single production lines (lines with no side a or b, like line 4 above).

Any help is highly appreciated!

[lbendlin]

Not sure why you would need a calculated table for that.  The data model can do the work for you.

see attached

[Anonymous]

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]

Table = SUMMARIZECOLUMNS('Main Table'[ID], 'Sub Table 1'[Line],
      "AverageWeight__lbs_ft_", CALCULATE(AVERAGE('Sub Table 1'[Weight (lbs/ft)]))
    )

[Anonymous]

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

[lbendlin]

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

[lbendlin]

Please provide the sample data that in usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[Anonymous]

Hi sorry about that, please see link below:

DEPDATA1101.0.accdb