Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 yellow (in the measure SumTransactions) I'd need the amounts from Account1 and Account2 summarized. So basically I'd need the DAX expression to say [If Matrix column Name is Account3 then sum amounts from row Account 1 and Account 3 else Sum TransactionAmount]
A complicating factor perhaps is that there are no Transactions on Account 3, its only a budgeting account.
The data model is set up for handling data with different granularities. Transactions are daily and budget is per month.
See link för example pbix file
and this for example data source
Matrix
Data model
Solved! Go to Solution.
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]))
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]))
User | Count |
---|---|
134 | |
74 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |