Multiplying two columns in Power Pivot

[YarANDlo]

Good afternoon!

In the "Report" file, I loaded two tables from the "One" file and the "Two" file. Next, in Power Pivot, I want to multiply the "Quantity" column of the table from the second file by the "Sum" column from the table of the first file. Then an error. Why?

 

[GraH - Guido]

A couple of mistakes. PowerPivot is not like Excel. You can refer to a column of another table without them having a relationship.
Then when you do and you want a calculated column, you need to perform the DAX VLOOKUP, which is RELATED.
See attached, but I cannot guarantee this will work on your real life data.

 

[YarANDlo]

I copied your formula and pasted it into my file, and still the error. I don't understand why it doesn't work for me

 

[GraH - Guido]

Did you create the relationship between the tables? Starting from table two to table one.

 

[YarANDlo]

Thanks
Super
Thank you so much