Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combining Two Tables in Matrix Visual

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) ...
  • johnt75's avatar
    johnt75
    4 years ago

    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

johnt75's avatar
johnt75
Super User
4 years ago

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