Forum Discussion
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)
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
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
2 Replies
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