Measure for data over multiple tables with multiple dimensions

Hi 2NV_DB ,

Based on my testing, please try the following methods:

1.Create the sample table.

2.Create the relationships between three tables.

3.Create the new measure to calculate sales values.

Sales with Multiplier = 
SUMX (
    'Sales',
    'Sales'[Sales] *
        LOOKUPVALUE (
            'Multiplier'[Multiplier],
            'Multiplier'[Customer Number], 'Sales'[Customer Number],
            'Multiplier'[Category], LOOKUPVALUE('Categories'[Categories], 'Categories'[Name], 'Sales'[Category Name])
        )
)

4.Drag the measures into the table visual. The result is shown below.

Best Regards,

Wisdom Wu

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