SUMX from two tables

Hi ppc_raltandi ,

According to your description, here is my solution.

Firstly, make sure that the relationships between the four tables are available.

As ReneMoawad  mentioned, create a table first.

NewTable =
CALCULATETABLE (
    SUMMARIZE (
        'Enrollment Type',
        'Enrollment Type'[Person ID],
        'Enrollment Type'[Type],
        "Fraction", CALCULATE ( SUM ( 'Enrollment Type'[Fraction] ) ),
        "Expenditure", CALCULATE ( SUM ( Expenditure[Spend] ) ),
        "Sum Product",
            CALCULATE ( SUM ( 'Enrollment Type'[Fraction] ) )
                * CALCULATE ( SUM ( Expenditure[Spend] ) )
    )
)

According to your description, I know that you want to calculate the division with the total “Fraction” and “Sum Product”. Therefore, we need to establish another measure.

Estimated =
DIVIDE ( SUM ( 'NewTable'[Sum Product] ), SUM ( 'NewTable'[Fraction] ) )

Final output:

Best Regards,
Community Support Team _ xiaosun

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