Forum Discussion
Combine Two Visual Tables
Unfortunately this won't work because Table 1 and Table 2 are visual tables, not existing tables from the data source. Each column is basically from different tables within the data.
I tried replicating this by using SUMMARIZECOLUMNS and then appending the results, but there are so many relationships it runs the computer out of memory before finishing.
The raw data is from Dynamics 365 and there are dozens of connections between the different tables.
Ok. So are the datapoints actual columns or measures?
I take it there is a common field between the tables: Data 1, which can be appended into a dimension table as in the model I posted?
If so, you can alter the measures to include the measures you already have along the lines of:
Combined =
VAR _T1 =
VALUES ( Table1[Data 4] )
RETURN
IF ( COUNTROWS ( _T1 ) = 1, "[Measure 1]", "[measure 2]" )
// The [Measures] are in between " " to be able to show as text in the visual
You say the tables are visuals. So how are they constructed?
Otherwise we would need to play with an actual dummy PBIX file to be able to try to help further
The datapoints are columns. Table 1 and Table 2 are constructed by using the table visual. Nothing fancy, each column from its respective table is dropped in. The problem is that Data 2 and Data 5 are columns from two entirely different tables, but the way the complex relationships work, pull the same data.
The data I'm using is sensitive so I unfortunately can't post specific examples, which I know is a pain when trying to figure the problem out.If you are pulling actual fields from tables to construct each visual, you could create mockup tables in Excel with the column structures for each table used. As an alternative, create a dummy PBIX without any values, filtering down rows and replacing names, all dowable in Power Query.
But up to you.