Combining Two Tables in Matrix Visual

[Anonymous]

Hey guys,

I've got the following revenue Matrix visualized, based on table called Source.

However I'd like to combine the revenue goals with this table. (Table called Goals)

Dragging these values into the visual doesn't work, because they are in 2 seperate tables. Result is this:

Joining the two tables in such a way that the goal is present in every line, and then using 'min' or 'max' or 'avg' values does get the correct amount per "Fonds". However the Total is not what I want. Result is this:

Any alternative way I can make this work?

With kind regards,

Lazzanova

[Anonymous]

The Goals table already is a dimensions table. But hey, your reply helped me get to the solution 😉 Thanks!

[johnt75 · Accepted solution]

Create a dimension table for Fonds like

Fonds Table = DISTINCT( UNION(
ALLNOBLANKROW( Source[Fonds]),
ALLNOBLANKROW( Goals[Fonds])
))

then create one-to-many relationships from the new table to both existing tables and use the column from the new table in your matrix visuals