rpmitchell
New Member
- Joined
- Jun 22, 2011
- Messages
- 43
Hello. I am trying to run a calculation that uses only certain rows from an unrelated table. Here is the scenario:
I have two tables with account numbers. Each account number is repeated multiple times in each table. The account value is different in each table. I built a pivot off Table1. I want a sum of the values in table 2, for all accounts in table 1, that happen to be a part of the pivot table filter context. The actual account number isn't on the pivot, just attributes of the account. I've tried:
Calculate([Sum(Tbl2[Value],
Filter(Tbl2,Tbl2[Account] = Tbl1[Account]))
but it doesn't work. It can't determine the value of the Tbl1 account in the current context, blah, blah, blah...
Any ideas on how to fix this formula?
I have two tables with account numbers. Each account number is repeated multiple times in each table. The account value is different in each table. I built a pivot off Table1. I want a sum of the values in table 2, for all accounts in table 1, that happen to be a part of the pivot table filter context. The actual account number isn't on the pivot, just attributes of the account. I've tried:
Calculate([Sum(Tbl2[Value],
Filter(Tbl2,Tbl2[Account] = Tbl1[Account]))
but it doesn't work. It can't determine the value of the Tbl1 account in the current context, blah, blah, blah...
Any ideas on how to fix this formula?