Multiplying across numerous tables

Hi AndyTrezise

I'm not absolutely sure. But you could try to use

=SUMX(PROJECTS;'Projects'[Number]*RELATED('Tasks'[Number]*RELATED('Assignments'[Number]))

Note: This is only vailid when ONE Project has ONE Task and ONE Assignement. In fact 1:1 relationship.

Greetings spuder

Hi  spuder

It should be possible to multiply across three tables without using the LOOKUPVALUE column.

If you create a calculated column in your Assignments table you can use a calculation like this

Column = RELATED('Projects'[Val]) * RELATED('Tasks'[Val]) * Assignments[Val]

This can also be done using a measure, or as a column in one of the higher tables, but you'd need to use RELATEDTABLE and SUM to complete.