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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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