This video shows how to use SUMX and RELATED Function when you need to multiply values from one table with values from another field in another table in the data model. This is similar to doing SUMPRODUCT in Excel yet, the columns are from different queries.

How to connect files and build data model:    • Connect Files to PowerBI and Build Da...