how to display values in matrix without affecting another columns value from different table

Hi gauri ,

To get the correct result in matrix, you need to extract a separate type table first:

Type Table = DISTINCT('Target table'[Type])

Create relationship between the type table and the target table:

Create a measure like this to calculate the actual values:

Actual =
CALCULATE (
    SUM ( 'Actual table'[Sales] ),
    FILTER (
        ALL ( 'Actual table' ),
        'Actual table'[Type] IN DISTINCT ( 'Type Table'[Type] )
    )
) + 0

Now the matrix can show the correct value:

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.