Forum Discussion

JC2022's avatar
JC2022
Icon for Helper III rankHelper III
3 years ago

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 co...
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

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 🙂

  • JC2022's avatar
    JC2022
    Icon for Helper III rankHelper III
    3 years ago

    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.