Forum Discussion
joshua1990
Post Prodigy
Post ProdigyCALCULATED COLUMN on not direct related table
Hi all!
Let's say I have 3 tables that are linked to each other 1:n
table 1 > table 2 > table 3
table 1
| Deparment | Group (Key to table 2) |
| AA | A |
| BB | B |
table 2
| Group | Order (Key to table 3) |
| A | 1 |
| A | 2 |
table 3
| Order | Value |
| 1 | 500 |
| 2 | 600 |
| 3 | 700 |
Now I would like to calculate the sum from table 3 and add it to table 1.
| Deparment | Group | Value |
| AA | A | 1100 |
| BB | B |
How would you do that?
7 Replies
- Migasuke
Memorable Member
joshua1990THanks a lot Migasuke. It's perfect. If I need a filter in Table 3, how would you add this into the function?
Something like CALCULATE(SUM(Table 3[Value]), RELATEDTABLE(Table 3), Table 3[Value] >=500))?
- Migasuke
Honestly not sure what filter you need.
FreemanZSuper User
hi joshua1990
you can plot a table visual with Table1[department] and a measure like:
measure = SUM(Table3[Value])
- joshua1990
As mentioned, it is about a calculated column
CNENFRNLCommunity Champion
Obviously, you make wrong relationship between table2 and table3.
- joshua1990
why?