CALCULATED COLUMN on not direct related table

[joshua1990]

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?

[Migasuke · Accepted solution]

Hi @joshua1990 ,

I think the procedure is quite easy. Please check my solution below:

Hope it helps!

[joshua1990]

THanks 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.

[CNENFRNL]

Obviously, you make wrong relationship between table2 and table3.

[joshua1990]

why?

[FreemanZ]

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