Using related in DAX calculated measures

Question

I am having two in Power pivot which are related by a key one contains sales and other contain cost,I am trying to multiply total sales by cost of item and want to use a calculated measure 

= SUM(ProductSales[Sales])*RELATED(MarketValue[Value]) 

I am getting the following error

This formula is invalid or incomplete: 'The column 'MarketValue[Value]' either doesn't exist or doesn't have a relationship to any table available in the current context.' 

Answer 1

use the following dax equation

=SUMX (
    ProductSales,
    ProductSales[Sales]
        * CALCULATE (
            VALUES ( MarketValue[Value] ),
            FILTER ( MarketValue, MarketValue[ProductID] = ProductSales[ProductID] )
        )
)

Want to learn more about Power Bi, Refer & learn Power bi   

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI