Sum/Calculate returning Blank

[rafaelsmoreno]

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,

[mattbrice · Accepted solution]

Would need to see sample file to help. 

[mattbrice · Accepted solution]

Would need to see sample file to help. 

[rafaelsmoreno]

Please find the file in the link here below. Thanks in advance for your help!

https://www.dropbox.com/s/p1bggixiv1m80sy/Budget.xlsb?dl=0

[Ashish_Mathur · Accepted solution]

That file is corrupt.  Also, share your model where you have written all formulas.  Tell us exactly where you are facing a problem.