How to multiply two tables with a connection of a dimension table

[JuradoKevin14]

I have this 3 tables.

My current script is sumx(Quantity,Quantity[Sales] * )

When I use the relate table it doesnt show the 2nd table.

Not sure where I go wrong.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how the year table is related, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Expected result measure: =
SUMX (
    ADDCOLUMNS (
        CROSSJOIN ( VALUES ( 'Year'[YEAR] ), VALUES ( CPTMODE[CPTMODE] ) ),
        "@sales", CALCULATE ( SUM ( Quantity[Sales] ) ),
        "@market%", CALCULATE ( SUM ( Market[Market%] ) )
    ),
    [@sales] * [@market%]
)