I have 3 fact tables (Revenues, Payroll and Expenses) and a Dim table (a Chart of Accounts). All tables have the same columns (period, acc, depart, etc) and a Value column. I intend to consolidate all the values in the Dim table so I can pivot the whole P&L at one single pivot table.
I manage to setup a Calculate to bring Values from tbRevenues and tbPayroll into the calculated column “Values” I created at the Dim table. however, by no means whatsoever neither the Calculate nor the Sum functions bring me the values from tbExpenses. All fact tables have connections to the Dim Table, and it is just not working.
I already tried deleting tbExpenses from the datamodel and connecting once again, but it just doesn’t work. Any insights on why this might be happening?
I created a measure SumVal that sums all values at the Dim table, and when I filter the accounts that should be coming from tbExpenses the result is “blank”.
Thanks in advance,
