Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Sum Above in a Matrix

  I'm having some trouble with a financial statement where I have transactions on acc 1 and 2 but the budget is set only for account3 which is a summary of acc 1 and acc 2.   In the field marked y...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I turned out to be no harder than

     

    SumTransactions = if(SELECTEDVALUE(Accounts[Name])="Account 3 (sum of acc 1 and 2)";
    CALCULATE(sum('Transaction'[Amount]);Accounts[Name]="Account 1")+
    CALCULATE(sum('Transaction'[Amount]);Accounts[Name]="Account 2");
    sum('Transaction'[Amount]))

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I turned out to be no harder than

 

SumTransactions = if(SELECTEDVALUE(Accounts[Name])="Account 3 (sum of acc 1 and 2)";
CALCULATE(sum('Transaction'[Amount]);Accounts[Name]="Account 1")+
CALCULATE(sum('Transaction'[Amount]);Accounts[Name]="Account 2");
sum('Transaction'[Amount]))