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

JuradoKevin14 — Fri, 02 Feb 2024 03:23:05 GMT

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.

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

Jihwan_Kim — Fri, 02 Feb 2024 04:09:48 GMT

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%] )

topic Re: How to multiply two tables with a connection of a dimension table in DAX Commands and Tips

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

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