Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
Novice asking again beginner questions … Thanks in advance for your help
There are 2 tables, TableResult and TableTarget
TableResult | |||
Region | Profit_Center | Revenue | Region_Target |
DE | PC1 | 100 | 1500 |
DE | PC2 | 100 | 300 |
NL | PC1 | 200 | 700 |
… | ... | ... | … |
TableTarget | ||
Region | Profit_Center | Revenue |
DE | PC1 | 1000 |
DE | PC1 | 500 |
DE | PC2 | 300 |
NL | PC1 | 700 |
Scenario:
Column Region_Target in TableResult needs to be calculated, using 2 tables.
Region_Target = Sum of Revenue in TableTarget with Filter using Profit_Center and Region from TableResult.
Following would give me the correct value for Region_Target in row1:
CALCULATE(SUM(TableTarget[Revenue]);FILTER(TableTarget;TableTarget[Region]="DE";TableTarget[Profit_Center]="PC1"))
But obviously I want to refernce to Profit_Center and Region in TableResult to calculate automatically for each row.
I tried with SUMX and CALCULATETABLE but did not come to any useful result. An ALLEPECXT needs to go in there as well I guess.
Any advice?
Solved! Go to Solution.
Hi @BobbyDollar
Region_Target = CALCULATE ( SUM ( TableTarget[Revenue] ); FILTER ( TableTarget; TableTarget[Region] = TableResult[Region] && TableTarget[Profit_Center] = TableResult[Profit_Center] ) )
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Hi @BobbyDollar
Region_Target = CALCULATE ( SUM ( TableTarget[Revenue] ); FILTER ( TableTarget; TableTarget[Region] = TableResult[Region] && TableTarget[Profit_Center] = TableResult[Profit_Center] ) )
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |