Forum Discussion

BobbyDollar's avatar
BobbyDollar
Frequent Visitor
7 years ago
Solved

Calculate with filter on multiple tables

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 ...
  • AlB's avatar
    AlB
    7 years ago

    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  Datanaut

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

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  Datanaut