Forum Discussion
Sum multiple fields from 3 different tables
Hi,
I have 3 different table views in PowerBI (please see my attached image for table1, table2 and table3). These are built from my datamodel (from different fact tables) and those tables have no connection (relationship) to eachother. Plus, these tables have their own filters on it. Now I would like to create a complete new table view (table4) with some calculations (sum) for the values. So for example: I would like to sum the blue fields from table1, table2 and table3 to calculate the blue field in table4. Please be aware the rows have different labels.
Can someone please tell me the best way to achieve this?
2 Replies
I think you have to make more clear how this calculation should work.
There has be rules why you bring white, large with can, small and printed all values together.
In the moment i do not understand the logic 🙂
This is a dummy dataset so the "white" and "large" labels are not a representation of the real data. The logic is not really there, because in reality table1 is the sales for services, table2 is the sales for solutions and table3 are G/L accounts. I am trying to sum some fields from table1, with some specific fields from table2 and some specific fields from the G/L account. This to visualize the total for some groups in table4.
So sum 3 fact tables without a relationship to calculate the total in a new table.
