topic Re: CALCULATED COLUMN on not direct related table in DAX Commands and Tips

CALCULATED COLUMN on not direct related table

joshua1990 — Sun, 05 Feb 2023 11:17:29 GMT

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

table 2

table 3

Now I would like to calculate the sum from table 3 and add it to table 1.

How would you do that?

FreemanZ — Sun, 05 Feb 2023 11:32:08 GMT

you can plot a table visual with Table1[department] and a measure like:

measure = SUM(Table3[Value])

CNENFRNL — Sun, 05 Feb 2023 11:39:13 GMT

Obviously, you make wrong relationship between table2 and table3.

joshua1990 — Sun, 05 Feb 2023 11:46:13 GMT

why?

joshua1990 — Sun, 05 Feb 2023 11:46:28 GMT

As mentioned, it is about a calculated column

Migasuke — Sun, 05 Feb 2023 11:50:47 GMT

Hi joshua1990 ,

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

Hope it helps!

joshua1990 — Sun, 05 Feb 2023 14:02:23 GMT

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 — Sun, 05 Feb 2023 21:04:33 GMT

Honestly not sure what filter you need.