Combining Data in Table Visual from Multiple Source Tables

Hi Drewz ,

You can try the measure below to meet your needs.

BudgetTotal =
SUM ( 'Task'[Task Budget] )
    + CALCULATE (
        SUM ( Projects[Project Budget] ),
        FILTER ( 'Projects', [Project ID] = MAX ( 'Task'[Project ID] ) )
    )

Charge Amount =
CALCULATE (
    SUM ( 'Time Entry'[Charge Amount] ),
    FILTER (
        'Time Entry',
        'Time Entry'[Project ID] = MAX ( 'Projects'[Project ID] )
            && 'Time Entry'[Task ID] = MAX ( 'Task'[Task ID] )
    )
)

PL = [BudgetTotal]-[Charge Amount]

Then you can get a result like this：

A demo for your reference is attached.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.