Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |