PowerPivot Sum of data between two tables

[rki1966]

I know I must be missing something, but my totals are not working for me. I am new to powerpivot.


=calculate(SUM(SummaryFinalView[NAV]),FILTER(SummaryFinalView,SummaryFinalView

=[Code]))

I get the sum of all the data instead of just the value of the code for the corresponding row. Every row has the same number in the calculation and should just be the sum of the NAV from the code in the other table.

There could be the same code in multiple rows.

 

[ImkeF]

Thing that strikes me is that "calculate" is not in capital letters. Did you use autocomplete when entering this formula? maybe the "calculate-part" is just being ignored?